This database introduces you to the built-in support for CGI access in FileMaker Pro . It uses a variety of layouts, each intended to display a particular kind of information.
When you first open this database, you are presented with the main menu, which allows you to choose from among several options. To choose an option, click the text label of the area you want to view. The icons in the toolbar at the top of most layouts let you change how the information is displayed without havi
ng to return to the Main Menu.
Note: Not all records in this database have data for every field. If you encounter a blank record while browsing one layout, you have reached the end of the information given for that layout. Choose another layout to see more information.
Toolbar Icons
The following toolbar icons are available from the layouts to which they apply. When you see these icons at the top of your layout, you use them to navigate to:
b!Using the CDML Reference Databasec
Back to databased
Previous recorde
Next Recordf
Main screeng
Find a specific tagh
Using the Navigation Layouts
Developer's Guide
This layout is intended to provide background information about FileMaker Pro's built-in CGI. Each record has an informative text field and examples, when appropriate.
Descriptions and Examples
This layout provides in-depth detail on a specific tag. An outline of the content provided on this layout is listed below:
What it does
This section describes the tag and important information that you should know about the tag.
Value is
This se
ction describes what the value should be in a name value pair, e.g.:
This section shows the syntax for the tag. Not all tags have a syntax section.
Syntax example(s)
This section shows one or more examples of how this tag can be used in an HTML file.
Other tags that are required
Lists other tags that are required. FileMaker Pro won't perform the action unless all required tags are present.
Parameters
Explains th
e parameters for the tag. Not all tags have parameters.
See also
Suggestions of other tags that should be read.
List View
This layout provides a list of the CDML tags that are supported in FileMaker Pro. Click the tag name to switch to the Decription view for the tag.
Go to the CDML tool
FindB
CDML Description and Example
ABAK>>
ABAI>>
Tag Type
What's NewB
FindT Tag Name`
Descriptiona
Findb
Canceld
Tag Syntax
FindT Tag Name`
Descriptiona
Findb
Canceld
Tag Syntax
Main Menu - RefB
What's New In CDML
What's New In CDML
AboutB
b Main Menu
b Main Menu
Programming: Keith Proctor Written by: Clay Maeckel
Geraldine Hyde Vahey
Keith Proctor
Editing: Kathy Osborne Testing: Seiichi Yahata
Monet Thomson Terry Barwegen
Monet Thomson Terry Barwegen
G-Click on a topic to display more information.^
List:
CDML Tag Index
Custom Web Publishing
G-Click on a topic to display more information.^
List:
CDML Tag Index
FileMaker Pro CDML Referenceu
HTML input typesv
Replacement tagsw
Action tagsy
Variable tagsz
All tags
1998, 2000 FileMaker, Inc. All Rights Reserved. FileMaker is a trademark of FileMaker, Inc., registered in the US and other countries, and Claris Home Page is a trademark of FileMaker, Inc.. Apple, Mac, and QuickTime are trademarks of Apple Computer, Inc., registered in the US and other countries.
E*Getting started with Custom Web PublishingG
-DeleteJ
Delete Record
Delete Record
Duplicate Recordu
DevGuide
Action
F Duplicate
H*Duplicates the record specified by -RecID.
About this guide
r sections within this Developer's Guide unless otherwise specified.
<input type="text" size=12 name="Country" value="Type a country name here">
<input type="submit" name="-Edit" value="Edit This Record">
</form>
Other tags that are required
-DB, -RecID, field name
See also
[FMP-CurrentRecID]
Note To publish your database oe o
With FileMaker Pro 5 and access to an intranet or the Internet, there are two ways to publish your FileMaker Pro databases on the Web:
Instant Web Publishing
Custom Web Publishing
Instant Web Publishing lets you publish your database on the Web quickly and easily, without changing your database or designing HTML Web pages or format files. All database files have the same interface, or appearance, which is specified by the FileMaker Pro Web Companion.
Custom Web Publishing allows youe files have the same interface, or appearance, which is specified by the FileMaker Pro Web Companion.
Custom Web Publishing allows you
section in this Developer
s Guide, onscreen Help, and chapter 11 of the FileMaker Pro User
s Guide
CDML tag syntax The CDML Tag Index in this CDML Reference database
Using the CDML Tool The "Using the CDML Tool" section in this Developer
s Guide
Working with the CDML Templates The "Using the CDML Tool" section in this Developer
<input type="submit" name="-Dup" value="Duplicate This Record">
</form>
Other tags that are required
-DB, -RecID, - Format
See also
[FMP-CurrentRecID]
record, the Web user must have Create permission for the database.
Syntax example(s)
Duplicate a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=6&-Dup">Duplicate record with ID 6</a>
Duplicate a record using a form action
<form action="FMPro" method="post">
<input type="hidden" name="-DB" value="name.fp5">
<input type=
-Edit
Edit Recordu
DevGuide
Action
HpUpdates the record specified by -RecID by populating the fields with the contents of any field
name/value pairs.
L(Publishing FileMaker Pro data on the Web
Here's an overview of the steps required to publish your database on the Web using Custom Web Publishing:
1. Create a database, or select an existing database to publish.
2. Create format files which contain HTML and CDML tags. Format files determine how Web users interact with your FileMaker Pro databases.
Perform the following steps on a computer connected to the Internet or an intranet via TCP/IP.
3. Move the format files and any image files to the Web folder in the FileMaker Pro 5
in this CD
abase
E*Getting started with Custom Web PublishingG
-EditJ
Edit Record
a form action
<form action="FMPro" method="post">
<input type="hidden" name="-DB" value="name.fp3">
<input type=
d Records">
</form>
Other tags that are required
-DB, -Format, field name
See also
-Max, -Skip
se by placing a link on an HTML page that contains, at a mi mi
What it does
Submits a search request using defined criteria. A format file is used to display the records found.
A Web user must have Browse permission in order to execute this action. You can improve the perceived performance of your Web database by using the -Max tag to limit the number of records returned.
Syntax example(s)
Find a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&country=USA&-Max=1&-Find">Find first USA record</a>
to customize the appearance of your FileMaker Pro data on the Web. You will need to create format files, HTML pages that contain CDML tags. CDML consists of special tags that enable FileMaker Pro to interact with standard HTML pages.
To create format files, you can use the CDML Tool to move the CDML tags into a text or HTML document.
Note To publish your database on the Web, you must have an Internet connection (usually provided though an Internet service provider) and an IP address.
Internet,
ys to pu
E*Getting started with Custom Web PublishingG
-EditJ
Edit Record
E*Getting started with Custom Web PublishingG
-EditJ
Edit Record
Other tags that are required
-DB, -MailTo, -MailFrom, -MailSub, -MailHost, any action tag
Finds all records and displays them using the specified format file.
A Web user must have Browse permission in order to execute this action. You can improve the perceived performance of your Web database by using the -Max tag to limit the number of records returned.
<input type="submit" name="-FindAll" value="Find All Records">
</form>
Other tags that are required
-DB, -Format
See also
-Max, -Skip
folder.
4. Make sure that the Web Companion plug-in is enabled in Application Preferences.
5. (Optional) Disable Instant Web Publishing in the Web Companion Configuration dialog box.
6. Choose the Home Page and change other settings in the Web Companion Configuration dialog box.
7. Open the database in FileMaker Pro 5.
8. Enable Web Companion Sharing in the File Sharing dialog box.
9. Give Web users access to your database by placing a link on an HTML page that contains, at a minimumC
, the IP address of the machine hosting the FileMaker Pro database files and the name and path of the format file.
For more information, see the "Using the CDML Tool" section.
ool" sec
E*Getting started with Custom Web PublishingG
-FindJ
Find Record
-Find
Find Recordu
DevGuide
Action
HeSubmits a search request using defined criteria. A format file is used to display the records found.
L!Custom Web Publishing
an overview
f_f_jf_f_fjfkjfkk\jkk\fb
E*Getting started with Custom Web PublishingG
-FindJ
Find Record
The CDML folder in the FileMaker Developer 5 installed directory contains three sample solutions you can use as a model for database publishing on the Web. The sample Web solutions include helpful comments to assist you in creating custom Web pages.
The Guest Book solution provides an example that allows Web users to "sign" a guest book form, which creates new records in the Guest Book.fp5 FileMaker Pro database.
The Employee Database solution is designed to demonstrate the most widB
ely used CDML tags.
The Shopping Cart solution demonstrates a site that enables Web users to browse through and purchase items from a catalog.
to browse through and purchase items from a catalog.
-FindAny
Find Any Recordu
DevGuide
Action
Find Any
H_Performs a find for a single random record. A format file is used to display the record found.
About the Web Companion plug-in
FileMaker Pro 5 functions as a Web server by communicating with Web browsers that request data from a FileMaker Pro 5 database. Similar to other Web server applications, the FileMaker Pro Web Companion delivers HTML pages and image files to the browser.
The FileMaker Pro Web Companion delivers the requested file via HTTP, or Hypertext Transfer Protocol. HTTP is a platform-independent mechanism for communicating between Web servers and browsers.
<input type="submit" name="-FindAll" value="Find All Records">
</form>
Other tags that are required
-DB, -Format
See also
-Max, -Skip
a Web server includes:
1. The Web user accesses the document through a URL (Uniform Resource Locator)
a unique address that contains the transfer protocol, the location of the Web server, and the name of a document. When a viewer types a URL or clicks a link, a Web browser locates the address and sends the request to the Web server.
2. The Web server retrieves the document identified in the URL and sends the HTML-formatted contents back to the browser.
3. The browser interprets the HTMC
L tags and displays the data.
Using the
About the Web Companion plug-inG
-ImgJ
Display Image
er submits the form, the Web server evaluates the URL and passes the data from the form to the CGI application for processing.
The CGI application name is included in the URL, so the Web server is notified to pass the information coming in from the Web browser to the CGI application for processing.
3. The CGI application collects the information and sends it to FileMaker Pro.
4. FileMaker Pro responds to the information and performs the requested action, such as creating a new
record or sending a found set of records back to the CGI application.
5. The CGI application receives and then processes the information that FileMaker Pro has sent by formatting the data as HTML.
6. The CGI application sends the HTML-formatted information to the Web server.
7. The Web server passes the HTML-formatted data to the Web browser.
Before FileMaker Pro 5, you had to use Web server software and a CGI application in order to publish your database on the Web. Now the FileMake
What it does
Returns an image specified by -DB, -RecID, and a field name, or specified by -DB and an image key.
A Web user must have Browse permission in order to execute this action.
An image key is a unique specifier to an image that is in a FileMaker Pro database. Use the [FMP-Field] tag to retrieve the image key from a container field.
Images stored in formats other than JPEG or GIF are converted before being sent to a Web user.
Important Usually there is no need to use th
is tag directly; the [FMP-Image] tag can be used to generate the correct URL for any container field.
HbReturns an image specified by -DB, -RecID, and a field name, or specified by -DB and an image key.
FileMaker Pro as a Web server
A CGI (Common Gateway Interface) application typically handles the interaction between a Web server and another software application on the same machine. Usually a CGI application receives data from a Web server and either processes it or sends it to another application for processing.
In general, publishing a database on the Web includes:
1. A Web user interacts with a form on a Web site and sends a request to the server, for example to submit name and address information.
2. When the
&pictures=&-Img">
Display the picture from record ID 11 and field name "pictures"</a>
H^Displays search or add form. Used to process any format files that do not require record data.
M+Considerations before publishing a database
There are many important factors to consider before publishing a database on the Web:
How Web users will interact with your Web site
How Web users will interact with the FileMaker Pro database
How many HTML pages and format files you will need
How the files that comprise your Web site will interact
How you will keep the data secure
Before creating the format files, spend some time planning what the purpose of the Web site will be, what content it will contain, and how you want
Web user submits the form, the Web server evaluates the URL and passes the data from the form to the CGI application for processing.
The CGI application name is included in the URL, so the Web server is notified to pass the information coming in from the Web browser to the CGI application for processing.
3. The CGI application collects the information and sends it to FileMaker Pro.
4. FileMaker Pro responds to the information and performs the requested action, such as creating a new
record or sending a found set of records back to the CGI application.
5. The CGI application receives and then processes the information that FileMaker Pro has sent by formatting the data as HTML.
6. The CGI application sends the HTML-formatted information to the Web server.
7. The Web server passes the HTML-formatted data to the Web browser.
Before FileMaker Pro 5, you had to use Web server software and a CGI application in order to publish your database on the Web. Now the FileMake
E+Considerations before publishing a databaseG
-ViewJ View Form
What it does
Displays search or add form. Used to process any format files that do not require record data.
Syntax example(s)
View a format file using a link
<a href="FMPro?-DB=db.fp5&-Format=query.htm&-View">"Take me to a search page"</a>
r Pro Web Companion performs the duties of both the Web server and the CGI application.
Note Third-party CGI applications that have been compatible with FileMaker Pro 3.0 should continue to work with FileMaker Pro Unlimited, which is availble seperately.
About the Web Companion plug-inG
-NewJ
New Record
What it does
Creates a new record and populates that record with the contents of any field name/value pairs.
A Web user must have Create permission in order to execute this action.
gramming how your pages will link to each other. If you diagram your links on paper before creating your Web site, you can modify the overall structure without updating the links. Make sure your pages are linked in a way that makes it easy for your viewers to navigate through the site.
Hosting a database on the Web makes your data available to anyone with a Web browser and access to the Internet. Be sure to protect valuable data with passwords.
Important security considerations:
There
What it does
Specifies the FileMaker Pro script that should be performed after the finding and sorting of records (if any) during processing of the action.
oring the home page" in the "Exploring the Guest Book format files" section for more information.
If you are using Custom Web Publishing
Database Nameu
DevGuide
Variable
Database & Layout
HNUsed to specify the database that all processing of the request will refer to.
Planning a Web site
In addition to enabling the Web Companion plug-in in Application Preferences, you'll need to modify the Web Companion configuration before using Custom Web Publishing. You should:
specify a custom Home Page
disable Instant Web Publishing
When Web users specify the IP address of a machine sharing a FileMaker Pro 5 database, they see the Built-in home page that is generated with Instant Web Publishing by default. Before using Custom Web Publishing, you'll need to create a custom home p
4.0 folder. Because of the nature of Web servers, all files in the Web folder can be accessed, replaced, or even deleted by savvy Web users. Don't put sensitive documents inside the Web folder.
If anyone opening a FileMaker file has Export Records privileges (even as a guest to a FileMaker file), they can then
atabase; do not include any path information. The database must be open in FileMaker Pro.
Syntax example(s)
View a format file using a link
<a href="FMPro?-DB=Names.fp5&-Format=query.htm&-View">Take me to a search page</a>
View a format file using a form action
<form action=
a FileMaker file has Export Records privileges (even as a guest to a FileMaker file), they can th
Fmublish the database on the Web. It's important to consider this before distributing or sharing your database.
E+Considerations before publishing a databaseG
Database NameL
<none>
What it does
Specifies the database that all processing of the request will refer to.
Value is
Name of the database, including the extension if any. The FileMaker Pro Web Companion uses only the name of the database; do not include any path information. The database must be open in FileMaker Pro.
Syntax example(s)
View a format file using a link
<a href="FMPro?-DB=Names.fp5&-Format=query.htm&-View">Take me to a search page</a>
View a format file using a form action
<form action=
are some important security considerations to keep in mind before sharing a FileMaker Pro 5 database:
With Instant Web Publishing, if you publish a layout that contains related fields, the related field data is published on the Web. Consider this before choosing which layouts are published. Also, the name of the database that contains the related fields is listed in the Instant Web Publishing Built-in home page. If you want to prevent the database name from appearing in the list of sha
red databases, insert an underscore at the end of the database name, for example, "Orders_" or "Orders_.fp5".
Format files must be stored in the Web folder in the FileMaker Pro 5 folder. Because of the nature of Web servers, all files in the Web folder can be accessed, replaced, or even deleted by savvy Web users. Don't put sensitive documents inside the Web folder.
If anyone opening a FileMaker file has Export Records privileges (even as a guest to a FileMaker file), they can then p
to structure your site.
The complexity of Web sites varies. One Web site might have a custom home page with a link to the FileMaker Pro Instant Web Publishing interface. Another might contain hundreds of files, such as image files, movies, standard HTML pages, and format files. The complexity of your Web site will depend on the amount of information you are broadcasting and the level of interaction your Web users will have with the information.
A simple flowchart is a useful way of dia
gramming how your pages will link to each other. If you diagram your links on paper before creating your Web site, you can modify the overall structure without updating the links. Make sure your pages are linked in a way that makes it easy for your viewers to navigate through the site.
Hosting a database on the Web makes your data available to anyone with a Web browser and access to the Internet. Be sure to protect valuable data with passwords.
Important security considerations:
There
After you determine what database activity your Web site will support, you should consider how much of your Web page is generated dynamically or statically. The dynamic approach incorporates content from your FileMaker Pro database into your format files before serving it to a Web browser. The static approach specifies all of the details needed to display a format file, such as record data or value list items. Most traditional HTML pages are examples of static Web publishing.
The most com
mon deciding factor on whether to publish your data dynamically is how frequently you change your FileMaker Pro data. If some of the data you
re publishing on your Web site is constant, you can take advantage of better performance by hard coding the data in the format file (static publishing). If you
re publishing data that is likely to change frequently, you should insert the data dynamically into your format file.
In some cases, the CDML tag syntax varies depending on whether you're us us
METHOD="POST">
<INPUT
TYPE="HID
he Web Companion plug-in is either not enabled or not installed correctly.
2. In the Web Companion View Setup dialog box, click Configure.
3. In the Web Companion Configuration dialog box, deselect Enable Instant Web Publishing.
4. Click OK.
=rslt.htm&-Script=Omit+Script&-Fin
before displaying the form in the Web browser. This is useful if displaying field value lists that m
-Script
Perform Scriptu
DevGuide
Before - The script is performed before the action.
Presort - The script is performed after the action and just before the sort.
After - The script is performed after the action.
Variable
Scripts
Do Script
Specifies the FileMaker script that should be performed after the finding and sorting of records (if any) during processing of the action.
age, and specify the filename in the Web Companion Configuration dialog box.
To choose which home page the Web Companion uses:
1. Move your custom home page into the Web folder inside the FileMaker Pro 5 folder.
2. Choose Preferences from the Edit menu, and then choose Web Companion.
If you don't see the Web Companion menu choice, the Web Companion plug-in is either not enabled or not installed correctly.
3. In the Web Companion View Setup dialog box, click Configure.
4. In the Con
figuration dialog box, for Home Page, choose the home page file you want to use.
5. Click OK.
Important Your home page must include a hyperlink containing the IP address of the computer publishing the FileMaker Pro database. Additionally, with Custom Web Publishing, the link must contain the name of the next format file to be displayed. See "Exploring the home page" in the "Exploring the Guest Book format files" section for more information.
If you are using Custom Web Publishing exc
ignored.
For all
other action tags, these name/value pairs are not needed.
Syntax example(s)
Find a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&color=red&-Max=1&-Find">Find first red record</a>
Field names are used to control find criteria or to upload data to a record. This is not a tag.
Usually the name portion of a name/value pair to be processed by FileMaker Pro is either a CDML action or variable tag. When a value for a specific field needs to be sent to FileMaker Pro, the name portion of the name/value pair is the name of a field in the FileMaker Pro database. Field names used in this manner should not start with the hyphen (-) character or contain any perio
[/FMP-ValueList]
</SELECT>
The HTML between the [FMP-valuelist: Department] and [/FMP-valuelist] tags is automatically repeated for every value in the value list. The actual value list items are substituted for the [FMP-valuelistitem] tag.
While static pages are simply served up, pages with dynamic values must first go through the FileMaker Pro Web Companion before being displayed
-Error
Error Responseu
DevGuide
Variable
Error
HySpecifies the HTML format file to be used to generate a response if any error occurs during the processing of the action.
What it does
Specifies the HTML format file to be used to generate a response if any error occurs during the processing of the action.
In the page you specify with this tag, you can test for which error occurred by using the [FMP-If] tag with CurrentError as the first parameter, or you can simply display the error number by using [FMP-CurrentError].
Value is
Path and name to the format file to use to display the error message.
Syntax example(s)
Attempt to create a new record using
an HTML file, any error takes you to the failure page
See the format file example.htm, located in the Employees_database folder in the Web folder to work with an example of dynamic and static CDML syntaF
E+Considerations before publishing a databaseG
-ErrorJ
Error ResponseL
<built in error page>
+++++
+++++
-Error
Error Responseu
DevGuide
Variable
Error
HySpecifies the HTML format file to be used to generate a response if any error occurs during the processing of the action.
ing the dynamic or static publishing. For example, if you are publishing a pop-up menu containing a value list of items that aren't likely to change, static publishing is best:
Department:
<SELECT NAME="Department">
<OPTION VALUE="" SELECTED>
<OPTION>Engineering
<OPTION>Marketing
<OPTION>Sales
</SELECT>
If, however, your value list is likely to change frequently, you can use the dynamic syntax, which retrieves the value list items from the FileMaker Pro database:
Department:
<SELECT NAME="Department">
[FMP-ValueList: Department, Department Names]
<option>[FMP-ValueListItem]
[/FMP-ValueList]
</SELECT>
The HTML between the [FMP-valuelist: Department] and [/FMP-valuelist] tags is automatically repeated for every value in the value list. The actual value list items are substituted for the [FMP-valuelistitem] tag.
While static pages are simply served up, pages with dynamic values must first go through the FileMaker Pro Web Companion before being displayed
lder can be accessed, replaced, or even deleted by savvy Web users. Don't put sensitive documents inside the Web folder.
ms" value="Enter data for rep one">
<input type="text" size=12 name="items" value="Enter data for rep two">
For the -New and -Edit tags, the value contains the data to be uploaded into a record. Multiple occurrences of a field allow the data to be put into separate repetitions of a repeating field.
For the -Find tag, the value is a find request on the specified field.
For the -Img tag, the first field name in the URL is the name of the container field to retrieve the image from. The value portion is ignored.
For all
other action tags, these name/value pairs are not needed.
Syntax example(s)
Find a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&color=red&-Max=1&-Find">Find first red record</a>
HLField names are used to control find criteria or to upload data to a record.
About format files
Format files are HTML pages that contain CDML tags. Typically, a format file performs one type of database transaction. For example, in the Guest Book solution in the Web folder, Web users make new records in a FileMaker Pro database using the gb_new.htm format file. When a record is added successfully, a second format file lets the Web user know the record has been added. A third format file notifies Web users if the new record could not be created. In addition to these three format files
ifies that a form will be filled out within the HTML document and notifies the Web server to send the contents of the form to FileMaker Pro. Because your Web pages contain some amount of interactivity
for example, capturing Web users
name and address information when they "sign" your guest book
ll need to use the HTML <FORM> tag:
<FORM ACTION="FMPro" METHOD=POST>
The ACTION attribute alerts the Web server, in this case FileMaker Pro 5, that FileMaker Pro will be processing the form.
The METHOD determines how the filled-out form is sent to the Web server, and it is typically sent with the POST value.
The INPUT tag is another common HTML tag that you
ll see in a format file. The INPUT tag creates an input element, similar to a field or a button, in the form. The INPUT tag has two commonly used attributes: TYPE and NAME. The TYPE attribute specifies the type of element that will be displayed on a form. For example, a one-line text area that captures a Web user
s first n
About format filesG
-FormatJ
Format FileL
<none>
What it does
Specifies the HTML format file used to generate a successful response during the processing of the action.
Value is
Path and name to the format file to use to display the response.
Syntax example(s)
Find any one record using a link, and display that record in "results.htm"
<a href="FMPro?-DB=db.fp5&-Format=results.htm&-FindAny">Return any record in the database</a>
Find any one record using a form action, and display that record in "results.htm"
, the Guest Book solution includes a home page, which is an HTML document that contains a link to the gb_new.htm format file.
The number and type of format files you'll need depends on how much your Web users will interact with your FileMaker Pro databases. The most common format file types perform actions, such as:
making new records
updating existing records
deleting records
searching for records
displaying one record or many records
Place the Web solution files (format fil
es, HTML pages, and image files) inside the Web folder (or a subfolder inside the Web folder). You might want to remove the sample Web solutions from the Web folder. Use relative links between files to prevent links from breaking. For information on creating relative or absolute links, refer to an HTML reference book.
Important All files in the Web folder can be accessed, replaced, or even deleted by savvy Web users. Don't put sensitive documents inside the Web folder.
-Format
Format Fileu
DevGuide
Variable
format
HjSpecifies the HTML format file used to generate a successful response during the processing of the action.
Planning format files
Format files can contain:
standard HTML elements
the HTML FORM tag
HTML INPUT tags
CDML tags
optional elements, such as GIF or JPEG graphics, animated GIFs, AIFF files, JAVA applets, QuickTime movies, tables, and frames
Every HTML page and format file contains Header and Body elements. The Header identifies the document as an HTML page and contains the document title. The Body contains most of the page content and, with Custom Web Publishing, the CDML tags.
The FORM tag spec
-Format
Format Fileu
DevGuide
Variable
format
processing of the action.
Value is
Path and name to the format file to use to display the response.
Syntax example(s)
Find any one record using a link, and display that record in "results.htm"
<a href="FMPro?-DB=db.fp5&-Format=results.htm&-FindAny">Return any record in the database</a>
Find any one record using a form action, and display that record in "results.htm"
HoSpecifies the name of the layout that is used to control which fields are available and how they are displayed.
HTML format file elements
In addition to HTML tags, format files also contain CDML tags, which interact directly with FileMaker Pro.
There are 3 types of CDML tags:
Action tags, which perform a specific action in FileMaker Pro. For example, the -new tag creates a new record in a FileMaker Pro database.
Variable tags, which specify an option for the Action tags. For example the -db tag specifies the database name that Web users will interact with.
Replacement tags, which act as placeholders and are swapped
tag creates an input element, similar to a field or a button, in the form. The INPUT tag has two commonly used attributes: TYPE and NAME. The TYPE attribute specifies the type of element that will be displayed on a form. For example, a one-line text area that captures a Web user
s first
About format filesG
-LayJ
Layout NameL
<none>
What it does
Specifies the name of the layout that is used to control which fields are available and how they are displayed.
The layout is used to: bind value lists to fields, control which fields are available to be displayed, allow access to related data, set the number of repetitions displayed in a repeating field, and control which fields are listed by the [FMP-LayoutFields] tag.
Value is
Name of the layout to use. If no layout is given, then the layout is considered to contain al
t are required
-DB, any action tag
ame would be:
<INPUT TYPE =TEXT NAME = "First Name">
The TEXT FIELD value in this example inserts a one-lined input area on an HTML page, which corresponds to a FileMaker Pro field. Other input types include radio buttons or text area, which yields a scrolling field. The NAME attribute specifies the field name.
You can also use the TYPE=HIDDEN attribute to send CDML tags to FileMaker Pro that won
t display in the Web browser. For example, each format file must specify the name of the F
The NAME attribute above uses the -db CDML tag, whose VALUE specifies the name of the FileMaker Pro database to work with.
For information on the other attributes of the INPUT tag, see the "HTML Input Types" section of the CDML Tag Index in this CDML Reference database.
value="Layout One">
<input type="submit" name="-
eb site
and how they are displayed.
The layout is used to: bind value lists to fields, control which fields are available to be displayed, allow access to related data, set the number of repetitions displayed in a repeating field, and control which fields are listed by the [FMP-LayoutFields] tag.
Value is
Name of the layout to use. If no layout is given, then the layout is considered to contain al
Layout Nameu
DevGuide
Variable
layouts
6with data from a FileMaker Pro database. For example, the [FMP-field] is replaced with data from a FileMaker Pro field.
CDML tags determine how Web users interact with the FileMaker Pro 5 database. For a complete list of all CDML tags and sample syntax, see the CDML Tag Index in this CDML Reference database.
ck Configure
About format filesG
-LOPJ
Logical OperatorL
he Action tags. For example the -db tag specifies the database name that Web users will interact with.
Replacement tags, which act as placeholders and are swapped
information on the other attributes of the INPUT tag, see the "HTML Input Types" section of the CDML Tag Index in this CDML Reference database.
ened by the FileMaker Pro 3.x or 4.x applications, and most new features, including the CDML Tool, will only operate with FileMaker Pro 5.
after changing a selection in a CDML Tool list box, you may need to click the Refresh button to update the list items.
if you've modified the CDML Tool in any way, and it no longer generates appropriate CDML syntax, install a new copy from the FileMaker Pro 5 CD-ROM.
Using the CDML ToolG
-MailCCJ
Carbon Copy for EmailL
<none>n
format file to handle each database interaction.
For step-by-step instructions, see the next two sections: "Using the CDML templates" and "Adding CDML tags to for
-MailCC
Carbon Copy for Emailu
DevGuide
Variable
HFSpecifies the email address of the person who should be carbon copied.
About the CDML Tool
The CDML templates provide general structure for several types of format files. The templates contain steps that can be used as a guide for inserting CDML tags.
-DB, -MailTo, -MailFrom, -MailSub, -MailHost, -MailFormat, any action tag
See also
-MailBCC
to for
-MailFrom
From for Mailu
DevGuide
Variable
HESpecifies the email address of the person who is sending the message.
L Adding CDML tags to format files
est Book.fp5 database.
When inserting fields with value lists, the CDML syntax will vary, depending on whether you want to have the value list items generated using the dynamic or static approach. In this example, the value list items will be generated using the static method, since the value list items aren't likely to
change.
To insert a field that displays a value list of choices on the Web browser:
1. In the Tags tab of the CDML Tool, select Fields Add (Static) in the Category list.
2. Select Radio Buttons from the Tags list.
The Radio Buttons tag type provides an interface that allows the Web user to choose from a list of items.
3. In the Fields list, select the Use Our Products field.
4. In the Value list box, select the Yes/No value list.
This adds the value list items to the syntax gener
ormat file.
Create one format file to handle each database interaction.
For step-by-step instructions, see the next two sections: "Using the CDML templates" and "Adding CDML tags to format files."
Important conside
Note These instructions build on the format file started in the previous section, "Using the CDML templates."
To insert Text field tags in the format file that adds records to the Guest Book.fp5 database:
1. In the Tags tab of the CDML Tool, be sure Guest Book.fp5 is the selected file in the Database list.
2. In the Category list, choose Fields (Add) Dynamic.
The category determines which CDML tags are displayed. The Fields (Add) Dynamic category displays tags that create field are.
2. In the Category list, choose Fields (Add) Dynamic.
The category determines which CDML tags are displayed. The Fields (Add) Dynamic category displays tags that create field are
ese steps, refer to the next section, "Adding CDML tags to format files" to complete the format file.
To start a format file that creates new records in the Guest Book.fp5 database:
1. Open an HTML editing application, such as Home Page 3.0.
2. Create a blank HTML editing document.
3. If applicable, switch
Detail Displays information about one record
Edit Edits existing records in a FileMaker Pro database
Edit Reply Notifies the Web user that a record has been edited successfully
New Creates new records in a FileMaker Pro database
New Reply Notifies the Web user that a new record has been created
Results Displays information about many records, typically after a search
Search Searches records in a FileMaker Pro database
The following example uses the CDML Tool to create a format fil
e that captures name and address information from the Web. The data will be stored in the Guest Book.fp5 database, available in the FileMaker Pro Web folder. After you've completed these steps, refer to the next section, "Adding CDML tags to format files" to complete the format file.
To start a format file that creates new records in the Guest Book.fp5 database:
1. Open an HTML editing application.
2. Create a blank HTML editing document.
3. If applicable, switch to the HTML editing mo
t -MailFormat
Format File for Mailu
DevGuide
Variable
Mail Format
HDSpecifies a text format file used for the body of the email message.
Using the CDML templates
contain the necessary standard HTML tags.
5. From the Web folder, open the Guest Book.fp5 database.
6. From the Web Tools folder, open the CDML Tool database.
7. In the Templates tab of the CDML Tool, choose Guest Book.fp5 from the Database list.
All open FileMaker Pro 5 database names appear in the Database li
8. Choose the Form View layout.
All layouts in the selected database appear in the Layouts list.
Note The layout choice determines which fields FileMaker Pro can access. Including the Layout name increases performance because it reduces the number of fields that FileMaker Pro needs to evaluate. However, all the fields that are added to the format file must be on the specified layout. If no Layout CDML tag has been specified, FileMaker Pro designates Layout 0 as a special virtua
n moved to the HTML editing application, you're ready to insert CDML tags to add the functionality to your format file. See the next section, "Adding CDML tags to format files," for more information.
on) list.
The CDML Tool templates are listed here.
10. Click the "Copy to clipboard" button to copy the New template to the Clipboard.
11. Switch to the HTML editing application and paste the New templa
te into the blank HTML document.
After the template has been moved to the HTML editing application, you're ready to insert CDML tags to add the functionality to your format file. See the next section, "Adding CDML tags to format files," for more information.
-DB, -MailTo, -MailFrom, -MailSub, -C6MailHost, any action tag
See also
-MailCC, -MailBCC
s all the fields in the database. Since it isn't an actual FileMaker Pro layout, it cannot be used to access layout-specific information such as related fields, field formats, or value lists assigned to fields.
9. Choose the New template from the Format File (Action) list.
The CDML Tool templates are listed here.
10. Click the "Copy to clipboard" button to copy the New template to the Clipboard.
11. Switch to the HTML editing application and paste the New template into the blank HTML G
document.
After the template has been moved to the HTML editing application, you're ready to insert CDML tags to add the functionality to your format file. See the next section, "Adding CDML tags to format files," for more information.
st be on the specified layout. If no Layout CDML tag has been specified, FileMaker Pro designates Layout 0 as a special virtua
e and Email Address. Web users will be able to type information into these fields from a Web browser, When they submit the form, their information will be added to the Guest Book.fp5 database.
When inserting fields with value lists, the CDML syntax will vary, depending on whether you want to have the value list items generated using the dynamic or static approach. In this example, the value list items will be generated using the static method, since the value list items aren't likely to
change.
To insert a field that displays a value list of choices on the Web browser:
1. In the Tags tab of the CDML Tool, select Fields Add (Static) in the Category list.
2. Select Radio Buttons from the Tags list.
The Radio Buttons tag type provides an interface that allows the Web user to choose from a list of items.
3. In the Fields list, select the Use Our Products field.
4. In the Value list box, select the Yes/No value list.
This adds the value list items to the syntax gener
n, to create a format file that makes new records in a FileMaker Pro database.
Note Cross references refer to other sections within this Developer's Guide unless otherwise specified.
General database publishing Onscreen Help and chapter 14 of the FileMaker Pro User
s Guide
Instant Web Publishing Onscreen Help an
d chapter 14 of the FileMaker Pro User
s Guide
Custom Web Publishing The "Getting started with Custom Web Publishing" section in this guide, onscreen Help, and chapter 11 of the FileMaker Pro Developer's Guide
CDML tag syntax The CDML Tag Index in this CDML Reference database
Using the CDML Tool The "Using the CDML Tool" section in this guide
Working with the CDML Templates The "Using the CDML Tool" section in this guide
Note Creating custom Web pages requires basic familiarity with
ch to the HTML doc
ument.
7. In the HTML document, insert the cursor in the line below Step 5.
The New template (and the other format file templates) contains steps that can be used as a guide for inserting CDML tags.
8. Paste the tag into the appropriate location of the format file.
This inserts the Text tag,which provides a field that Web users can enter data into.
9. Repeat the steps above to insert the Last Name and Email address fields.
This inserts the CDML tags that provide fields for Last Nam
t type="text" name="-MailBCC" value="Terry@Company.COM">
-DB, -MailTo, -MailFrom, -MailSub, -MailFormat, any action tag
See also
-MailCC, -C
MailBCC
3. In the Fields list, select the Use Our Products field.
4. In the Value list box, select the Yes/No value list.
This adds the value list items to the syntax gener
This layout gives detailed information about each Event which FileMaker Pro 2.0 supports. The information supplied includes the event class, ID, terminology, and input and result parameters. The
Examples
field provides some samples for using the event using a fictitious syntax similar to the HyperTalk language. The
Notes
field provides some additional information about the event. Extensions to
!Gthe standard parameters for events are denoted by their bold keywords.
What it does
Specifies the email address of the person who is sending the message.
mApple Event Suites. Clicking on the title of an Object or Event will switch to a detailed view of the item.
Object Hierarchy
This layout provides a view of the containment hierarchy in FileMaker Pro. That is, objects appearing to the right are contained in objects to the right of them. This containment is indicated by dotted
^gray lines. Clicking on the title of an Object will switch to a detailed view of that class.
Objects and Events List
This layout provides a list view all of the Events and Objects which are supported in FileMaker Pro 2.0. It provides the same infomation as the
FileMaker Objects Map
in a different manner. Clicking on
Lthe title of an Object or Event will switch to a detailed view of the item.
Using the Content Layouts
FileMaker Events
splays information in the format file without interacting with the database, such as the current Sort field
lBCC" value=
out the database to let you change the information displayed without having to return to the main screen. The forward and backward arrow icons above switch to the next and previous
records, respectively. You can also use the layout pop-up menu in the status area, record book or scripts to move through the database.
FileMaker Events
Displays information in the format file without interacting with the database, such as the current Sort field
Using the CDML ToolG
1H -MailFromJ
From for MailL
<none>
This database is designed to introduce users to the support for Apple events in FileMaker Pro 2.0. It uses a variety of layouts, each intended to display a particular kind of information.
When you first open this database, you are presented with the main screen, which allows you to choose from among several options. To choose an option, click on the text or the button icon next to it.
These icons are used throughout the database to let you change the information displayed without having to return to the main screen. The forward and backward arrow icons above switch to the next and previous
records, respectively. You can also use the layout pop-up menu in the status area, record book or scripts to move through the database.
cts which are supported in FileMaker Pro 2.0, grouped according to
ind records
Hidden Contains CDML tags that don't display in the Web browser. Useful for specifying the database name or determining which format file is displayed after the Web user clicks the Submit button.
Links Inserts CDML syntax inside an HTML link
Logical Use conditional "If, Then, Else" statements. Useful for reporting a variety of error messages in one format file.
Looping Repeats the HTML and CDML tags for each item between [tag] and [/tag]. Useful for displaying records in a
table-like format.
Replacement Strips out the CDML tags and replaces them with field data. Useful for dynamically displaying FileMaker Pro field data or information, such as the Current Date.
Variables (Add) Auto-enters values into a field without displaying values in the Web browser. Useful for tracking statistics about Web users.
Variables (Display) Displays information in the format file without interacting with the database, such as the current Sort field
Note: not all records in this database have data for every field. If you encounter a blank record while browsing one layout, you have reached the end of the information given for that layout. Choose
2another layout to continue with more information.
Using the Navigation Layouts
$
Introduction to Apple Events
This layout is intended to provide background information about Apple events, the Apple Event Object Model, and the Apple Event Registry, as well as information about support for Apple events in
^FileMaker Pro. Each record has an informative text field as well as an (optional) example.
FileMaker Objects Map
This layout is a navigation aid for getting to the information about a specific Event or Object. It displays all of the Events and Objects which are supported in FileMaker Pro 2.0, grouped according to
Action Performs an action in a FileMaker Pro database, such as create a new record or executing a script
Email Sends Email using data from a FileMaker Pro database or an HTML form
Fields (Add) Dynamic Retrieves field information before displaying the form in the Web browser. This is useful if displaying field value lists that mig
ht change.
Fields (Add) Static Displays field information that has been hard coded when creating format files. Useful for value list items or field data that won
t change.
Fields (Display) Displays field data that does not need to be updated or added. Useful when Web users are just browsing database data.
Fields (Updating) Allows Web users to edit records, which includes adding, editing, and deleting field data
Find operators Contains search operator tags that determine how Web users f
ated below.
5. Click the "Copy to clipboard" button to copy the CDML tag syntax to the Clipboard.
6. In the HTML document, insert the cursor below the Email field you inserted in Step 5.
7. Paste the tag into the format file.
8. Edit the HTML radio button label text. Replace the first label value, "Label" with "Yes." Replace the second label value, "Label" with "No."
9. Save the document to the Web folder inside the FileMaker Pro 5 folder.
When this document is accessed from a Web
browser, the Web user will be able to enter values in the inserted fields to update the Guest Book.fp5 database.
For information on specific tags, see the CDML Tag Index in this CDML Reference database. For more information on dynamic and static publishing, see "Dynamic vs. static database publishing" in the "Considerations before publishing a database" section.
Explore the Guest_book format files in the Web folder to see the completed solution.
Use this CDML tag type To create a form
as on the format file.
3. In the Tags list, choose Text Field.
The Text Field tag inserts a one-line field in the HTML page.
Note If the pop-up menu displays blank or inappropriate choices, click the Refresh button.
4. In the Fields list, select the First Name field. The following syntax appears in the box below:
First Name: <INPUT TYPE="text" NAME="First Name" VALUE="">
5. Click the "Copy to clipboard" button to copy the CDML syntax to the Clipboard.
6. Switch to the HTML doc
ument.
7. In the HTML document, insert the cursor in the line below Step 5.
The New template (and the other format file templates) contains steps that can be used as a guide for inserting CDML tags.
8. Paste the tag into the appropriate location of the format file.
This inserts the Text tag,which provides a field that Web users can enter data into.
9. Repeat the steps above to insert the Last Name and Email Address fields.
This inserts the CDML tags that provide fields for Last Nam
-MailCC, -MaC
ilBCC
]E%Exploring the Guest Book format filesG
2H -MailHostJ
Host for MailL
<none>
What it does
Specifies the address of the SMTP server host that will actually send the message.
des an interface that allows the Web user to choose from a list of items.
3. In the Fields list, select the Use Our Products field.
4. In the Value list box, select the Yes/No value list.
This adds the value list items to the syntax gener
-MailHost
Host for Mailu
DevGuide
Variable
HRSpecifies the address of the SMTP server host that will actually send the message.
M%Exploring the Guest Book format files
This section examines the format files that comprise the Guest Book Web site, available in the Web folder in the FileMaker Pro 5 folder. The Guest Book solution provides an example that allows Web users to create new records in the Guest Book.fp5 FileMaker Pro database.
This table shows the files and folders included with the Guest Book Web solution.
gif The background image for the Guest Book Web pages
The Guest book format files are fairly simple examples because Web users have limited interaction with a FileMaker Pro database. Web users can create new records
- - - - - - - - - - - - - - - - - -
Guest Book.fp5 The FileMaker Pro database file that stores new records created by Web users
default.htm An HTML page that contains a link to the gb_new.htm format file
gb_new.htm The format file Web users interact with in order to create records in the Guest Book.fp5 database
gb_sum.htm The format file that notifies Web users that their record has been added successfully
gb_err.htm An HTML page that notifies Web users if a new record could not be cr
eated
Images folder The folder containing all the image files used in the Guest Book Web solution
arrow_gold.gif The image file that indicates which fields are required
art.jpg An image file positioned similarly to a corporate logo on the Guest Book Web pages
background.gif The background image for the Guest Book Web pages
The Guest book format files are fairly simple examples because Web users have limited interaction with a FileMaker Pro database. Web users can create new records
-DB, -MailTo, -MailFrom, -MailHost, -MailFormat, any action tag
See also
-MailCC, -MailBCC
Pro database. Web users can create new record
ement CDML tags, you'll need to supply the following minimum information in the link before any CDML replacement tags can be replaced with data by FileMaker Pro:
-DB, -MailTo, -MailFrom, -MailHost, -MailFormat, any action tag
See also
-MailCC, -MailBCC
Operatoru
DevGuide
Variable
F9Operator (Hidden)
Operator (Number/Dates)
Operator (Text)
HjSpecifies the comparison operator to apply to the field name/value pair that follows it in a -Find action.
Exploring the Reply format file
The gb_err.htm file is returned when a record cannot be added to the Guest Book.fp5 database. An error is likely to occur when fields specified by the database designer in the FileMaker Pro Validation panel of Entry Options don't contain a required value.
Similar to the Guest Book home page, default.htm, all of the tags are HTML tags. For a more complex error handling example, view the errors.htm sample file in the Employee_database folder in the Web folder.
Note If you don't use the -eB
rror CDML tag, which species the Error Response filename, the FileMaker Pro Web Companion will automatically display an error page.
E%Exploring the Guest Book format filesG
-RecIDJ Record IDL
<none>
Like all HTML pages, the default.htm Guest Book solution home page contains the standard HTML tags indicating where the document Head and Body start and end. It also contains additional elements that are common on HTML pages, such as a JPEG graphic, text, and a link to the gb_new.htm format file. Because the home page doesn
t interact directly with a FileMaker Pro database, it contains only HTML
not CDML
tags.
Before using Custom Web Publishing, you'll need to create a custom home page ay with a FileMaker Pro database, it contains only HTML
not CDML
tags.
Before using Custom Web Publishing, you'll need to create a custom home page a
-DB, -MailFrom, -MailSub, -MailHost, -MailFormat, any action tag
See also
-MailCC, -MailBCC
t contain is the path to the next format file to display. Below is a sample of an HTML hyperlink tag:
<A HREF=gb_new.htm>Guest Book</A>
If, however, the next format file to be displayed does contain Replac
nd specify the filename in the Web Companion Configuration dialog box. For more information on changing the default home page, refer to "Configuring the Web Companion plug-in" in the "Considerations before publishing a database" section.
Your home page must include a hyperlink (link) with the IP address of the computer where the database you want to publish on the Web is shared.
You can also include:
a description of what your database contains
a Table of Contents or a list of what
your Web pages contain
your email address, or an automated email link so users can contact you if they have questions
your company logo or other graphics
If the next format file to be displayed doesn't contain any Replacement CDML tags, the only information that the hyperlink must contain is the path to the next format file to display. Below is a sample of an HTML hyperlink tag:
<A HREF=gb_new.htm>Guest Book</A>
If, however, the next format file to be displayed does contain Replac
-MailTo
To address for mailu
DevGuide
Variable
HFSpecifies the email address of the person who the message is going to.
Exploring the home page
The gb_new.htm file is the format file used to create new records in the Guest Book.fp5 FileMaker Pro database. It is accessed by a link from the default.htm home page.
The bold text below is HTML and CDML syntax that appears in the gb_new.htm format file.
<FORM ACTION="FMPro" METHOD="POST">
The FORM HTML tag specifies that a form will be filled out within the HTML document and alerts the Web server, in this case FileMaker Pro 5, that FileMaker Pro will be processing the form.
<INPUT TY
Max Recordsu
DevGuide
Variable
Max Records
HISpecifies the maximum number of records that should be returned per page.
L$Exploring the New Record format file
YPE attribute is HIDDEN to prevent the CDML from being displayed in the Web browser.
The NAME attribute specifies the -db CDML tag, whose VALUE specifies the exact name of the FileMaker Pro database that will store the records created from the Web browser.
The previous two lines determine which format file is displayed after the Web user clicks the Submit button.
The -format tag specifies the name of the format file displayed when the form has been processed successfully.
The -error tag is used if FileMaker Pro cannot process the form. For example, if all the required fields do not have values, FileMaker Pro will display the gb_Err.htm format file.
<INPUT TYPE="hidden" NAME="-la
s for mailL
<none>
What it does
Specifies the email address of the person who the message is going to.
mat file is displayed after the Web user clicks the Submit button.
The -format tag specifies the name of the format file displayed when the form has been processed successfully.
The -error tag is used if FileMaker Pro cannot process the form. For example, if all the required fields do not have values, FileMaker Pro will display the gb_Err.htm format file.
<INPUT TYPE="hidden" NAME="-
ss fields all have the Validation option "Not empty" selected in Field Options.
The "radio" and "checkbox" types are used to present the Web user with a list of options to choose from.
The -new tag alerts FileMaker Pro to create a new record in the database whose name is specified by the VALUE in the -db tag.
E%Exploring the Guest Book format filesG
-MaxJ
Max RecordsL
"field" in the Web browser. These three text areas correspond with the field names in the FileMaker Pro database Guest Book.fp3. The First Name, Last Name, and Email Add
y" VALUE="Form View">
The -lay CDML tag specifies the name of the layout that is used to control which fields are available to be displayed. The layout also provides value lists for fields, allows access to related data, and controls which fields are listed. If no layout is specified, the layout is considered to contain all fields in the database (but not related fields).
The next HTML INPUT tags define input objects that reference the First Name, Last Name, and Email Address fields on t
The "text" TYPE signifies that text will be entered into a one-lined box. The corresponding VALUE is blank, which will display as an entry "field" in the Web browser. These three text areas correspond with the field names in the FileMaker Pro database Guest Book.fp5. The First Name, Last Name, and Email Addre
IThe gb_sum.htm file is returned when a record is successfully created in the Guest Book.fp5 database. The [FMP-field] CDML tags add a personal touch by including the first and last name that the Web user typed in the gb_add.htm format file. A link at the bottom of the document returns the Web user to the home page, default.htm.
E%Exploring the Guest Book format filesG
OperatorL
begins with
2htm format file. A link at the bottom of the document returns the Web user to the home page, default.htm.
The "text" TYPE signifies that text will be entered into a one-lined box. The corresponding VALUE is blank, which will display as an entry "field" in the Web browser. These three text areas correspond with the field names in the FileMaker Pro database Guest Book.fp3. The First Name, Last Name, and Email Add
The -db CDML tag is critical to every format file; it specifies the name of the database that the Web user interacts with.
The TYPE attribute is HIDDEN to prevent the CDML from being displayed in the Web browser.
The NAME attribute specifies the -db CDML tag, whose VALUE specifies the exact name of the FileMaker Pro database that will store the records created from the Web browser.
The previous two lines determine which format file is displayed after the Web user clicks the Submit button.
The -format tag specifies the name of the format file displayed when the form has been processed successfully.
The -error tag is used if FileMaker Pro cannot process the form. For example, if all the required fields do not have values, FileMaker Pro will display the gb_Err.htm format file.
<INPUT TYPE="hidden" NAME="-la
reate a format fil
e that captures name and address information from the Web. The data will be stored in the Guest Book.fp5 database, available in the FileMaker Pro Web folder. After you've completed these steps, refer to the next section, "Adding CDML tags to format files" to complete the format file.
To start a format file that creates new records in the Guest Book.fp5 database:
1. Open an HTML editing application, such as Home Page 3.0.
2. Create a blank HTML editing document.
3. If applicable, switch
-RecID
Record IDu
DevGuide
Variable
F Record ID
HlDefines which record should be operated on. Used mainly by the -Edit, -Dup (duplicate), and -Delete actions.
Exploring the Error page
Syntax example(s)
Delete a r
ror page.
E%Exploring the Guest Book format filesG
-RecIDJ Record IDL
<none>
What it does
Defines which record should be operated on. Used mainly by the -Edit, -Dup (duplicate), and -Delete actions.
Value is
A record ID, which is a unique specifier to a record in a FileMaker Pro database. The [FMP-CurrentRecID] replacement tag is used to get the ID of a record.
Syntax example(s)
Delete a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=4&-Delete">Delete record with ID 4</a>
<input type="submit" name="-Delete" value="Delete This Record">
</form>
Other tags that are required
-DB, -Format, any action tag
See also
[FMP-CurrentRecID]
ror page.
E%Exploring the Guest Book format filesG
-RecIDJ Record IDL
<none>
What it does
Specifies the comparison operator to apply to the field name/value pair that follows it in a -Find action.
Value is
The operator to use. There are short and long versions of each operator. The default operator is "begins with". The list of valid operators is:
Short Long FileMaker Pro Equivalent Operator
eq equals =word
cn contains "word"
bw begins with word*
ew ends with *word
gt greater than > word
gte greater than or equals >= word
lt less than < word
lte less t
han or equals <= word
neq not equals omit, word
You can use any FileMaker Pro Find operator by specifying the begins with (bw) parameter. E.g., To specify the "Find Content Match" (==) operator, you would specify the begins with parameter (bw) and then you would place the characters "==" before the actual search criteria. The required lines would look like this:
<input type="hidden" name="-Op" value="bw">
<input type="text" name="First" value="==Keith">
Syntax example(s)
cE ReferenceG
-SkipJ
Skip RecordsL
<none>
What it does
Tells FileMaker Pro how many records to skip before displaying the set of records. Used with the -Max tag to display a series of pages with a subset of the current found set on each one.
Value is
A number from 0 through 2147483647, or the word "All". If the value is greater then the number of records in the found set or the value is "All" then the last record is displayed. The default value is 0.
Syntax example(s)
Display some records using a link
<a href="FMPro?-DB=dbater then the number of records in the found set or the value is "All" then the last record is displayed. The default value is 0.
Syntax example(s)
Display some records using a link
<a href="FMPro?-DB=db
|ecord">
</FORM>
Other tags th
eater then the number of records i
s that are requireC3d
-DB, -Format, -Find or -FindAll
See also
-Max
Syntax example(s)
Delete a r
-Skip
Skip Recordsu
DevGuide
Variable
Skip Records
HRTells FileMaker Pro how many records to skip before displaying the set of records.
M Reference
Follow these tips to increase the performance of your Web site:
Design layouts with the Web in mind; layouts should only contain fields that you are publishing.
Use the -lay CDML tag to reduce the number of fields FileMaker Pro 5 needs to evaluate. If a field included on a format file is not on the layout specified with the -lay CDML tag, it will not appear.
Use static Web publishing with fields containing value lists if the value list items won't be changing. For more information
-SortField
Sort Fieldu
DevGuide
Variable
Sort Field
H2Specifies the field that will be used for sorting.
Performance tips
Problem:
After changing a selection in the CDML Tool, the list no longer presents appropriate choices.
Solution:
Click the Refresh button after changing a selection in the CDML Tool. If this does not update the choices in a list, close and re-open the CDML Tool.
Problem:
Upper ASCII characters don't display properly in the Web browser.
Solution:
HTML doesn't offer direct support of upper ASCII or non-ASCII characters. To use these extended characters, you need to encode them by typ
ver issues. Refer to an HTML reference book for general tips.
<input type="submit" name="-FindAll" value="Display record 10">
</form>
Other tags that are requireC3d
-DB, -Format, -Find or -FindAll
See also
-Max
, see "Dynamic vs. static database publishing" in the "Considerations before publishing a database" section.
Use the -max CDML tag to reduce the number of records being returned.
If you're publishing graphic images directly from a container field, store JPEG and GIF images (instead of PICT or BMPs). This prevents FileMaker from converting the images before passing them to a Web browser.
Use small graphics created with a lower dpi (dots per inch). Because monitors display images aC
t a relatively low dpi, creating images that store higher dpi
s add unnecessary overhead.
Note Many performance issues are general HTML/Web server issues. Refer to an HTML reference book for general tips.
E ReferenceG
-SortFieldJ
Sort Field
.n't displaying replacement data.
Solution:
Before any CDML replacement tags can be replaced with data by FileMaker Pro, the URL accessing the format file containing the tags must have the following minimal information:
Each CDML tag "name" attribute must be followed by a "="
Upper ASCII characters may need to be encoded (for example, you can't have a space in a URL).
Problem:
Replacement tag
ing decimal or entity references. When working with some of the CDML Replacement tags, for example, publishing data from a FileMaker Pro field, you can enable FileMaker Pro to automatically encode upper ASCII characters by choosing the HTML encoding parameter in the CDML Tool. For more information on upper ASCII character encoding, refer to an HTML reference book.
Problem:
A URL containing CDML tags has not been processed correctly.
Each CDML tag (and its accompanying value) must be separated by an ampersand (&)
Each CDML tag "name" attribute must be followed by an "="
Upper ASCII characters may need to be encoded (for example, you can't have a space in a URL).
Problem:
Replacement tags are
What it does
Specifies the field that will be used for sorting.
This tag can been used multiple times to perform multiple field sorts. The order in which the tag appears in the URL or format file will determine the order of the fields.
Value is
Name of a FileMaker Pro field.
Syntax example(s)
Specify sort field using a link
<a href="-DB=Contacts&-Format=format.html&-SortField=First+Name&-FindAll">Sort by First Name</a>
<input type="submit" name="-FindAll" value="Sort by First Name">
</form>
Other tags that are required
-DB, -Format, -Find or -FindAll
See also
-SortOrder
lue) must be separated by an ampersand (&)
Each CDML tag "name" attribute must be followed by an "="
Upper ASCII characters may need to be encoded (for example, you can't have a space in a URL).
Problem:
Replacement ta
-SortOrder
Sort Orderu
DevGuide
Variable
Sort Order
H"Indicates the direction of a sort.
Troubleshooting
-TokenJ
TokenL
<none>
What it does
Passes any value to a format file. Whatever value you set -Token equal to can be retrieved in the format file by using the [FMP-CurrentToken] tag, or it can be used in an [FMP-If] tag.
<a href="-DB=Contacts&-Format=format.html&-Token=The+Token&-View">Set a token</a>
Up to nine tokens can be used by using a slightly different syntax for the
token tags. The variable tag -Token can have an optional token specifier of the form -Token.X
where X c
an be the characters 0 through 9. If no period follows the -Token keyword then token
one is implied. To retrieve the value of a token the FMP_CurrentToken will accept another
parameter that is a number, of value 0 through 9. If there is no number parameter, but there
is a period, then token zero would be returned. CurrentToken constant for the FMP-If tag
would then have an optional specifier that would look like CurrentToken:3 if you want to
compare the contents of token three to something
else.
Example format file snippet:
<!-- Pass the value of token three onto the next request -->
<INPUT TYPE="HIDDEN" NAME ="-Token.3" VALUE ="[FMP-CurrentToken: 3, HTML]">
Tokens can be used on the right side of an FMP-If using the intratag replacement syntax:
[FMP-If: CurrentToken:5.eq.{CurrentToken:6}]
<B>Token 5 equals token 6.</B>
[/FMP-If]
Other tags that are required
-DB, -Format, any action tag
See also
[FMP-CurrentToken]
tInRect
AECountItems
SetEOF
LoadRe
{CurreE
ntToken:6}]
<B>Token 5 equals token 6.</B>
[/FMP-If]
Other tags that are required
-DB, -Format, any action tag
See also
[FMP-CurrentToken]
o something else.
t"[FMP-ClientAddress]
Client Addressu
Replacement
Client Address
HF[FMP-ClientAddress] is replaced with the current client's domain name.
available, the client's IP number is provided.
Note Looking up the domain name of client can be a lengthy operation; consider using [FMP-ClientIP] if all you want to track is a specific client.
Syntax example(s)
Return current address using an HTML file
Your Domain Address is: [FMP-ClientAddress]
<!-- After processing it could look like:
Your Domain Address is: macB4hineone.company.com
-->
See also
[FMP-ClientIP]
[FMP-ClientAddress]J
Client Address
What it does
[FMP-ClientAddress] is replaced with the current client's host name.
If the host name is not available, the client's IP number is provided.
Note Looking up the host name of client can be a lengthy operation; consider using [FMP-ClientIP] if all you want to track is a specific client.
Syntax example(s)
Return current address using an HTML file
Your host address is: [FMP-ClientAddress]
<!-- After processing it could look like:
Your host address is: machineone.coB*mpany.com
-->
See also
[FMP-ClientIP]
[FMP-ClientIP]J
Client IP Address
1What it does
[FMP-ClientIP] is replaced with the current client's IP address.
Syntax example(s)
Return client's current IP address using an HTML file
Your IP number is: [FMP-ClientIP]
<!-- After processing it could look like:
Your IP number is: 199.199.9.9
-->
See also
[FMP-ClientAddress]
t [FMP-ClientIP]
Client IP Addressu
Replacement
Client IP Address
H@[FMP-ClientIP] is replaced with the current client's IP address.
[FMP-ClientPassword]J
Client Password
What it does
[FMP-ClientPassword] is replaced with the current HTTP-authenticated client password.
Syntax example(s)
Return the client password using an HTML file
Your password is: [FMP-ClientPassword]
<!-- After processing it could look like:
Your password is: secret
-->
it$[FMP-ClientPassword]
Client Passwordu
Replacement
Client Password
HU[FMP-ClientPassword] is replaced with the current HTTP-authenticated client password.
[FMP-ClientType]J
Client Type
What it does
[FMP-ClientType] is replaced with the current browser client type.
The browser client type, also known as the "user agent", is an arbitrary text string of up to 256 characters sent by the browser in the HTTP request header. The client type can be used in the [FMP-If] tag with the "contains" operator to determine what sort of browser the person accessing your Web site is using.
Syntax example(s)
Return the client type using an HTML file
Your browser type is: [FMP-Client
Type]
<!-- After processing it could look like:
Your browser type is: Mozilla/3.01 (Macintosh; I; PPC)
-->
Checking the type of browser in an HTML file
[FMP-If: ClientType .cn. Mozilla/2.0 ]
This page contains JavaScript that will work only on
Microsoft Internet Explorer 2.1 (Mac PPC) Mozilla/2.0 (compatible; MSIE 2.1; Mac_PowerPC)
Microsoft Internet Explorer 3.0 (Win 95) Mozilla/2.0 (compatible; MSIE 3.0; Windows 95)
America Online 3.0 (Mac PPC) Mozilla/2.0 (compatible; AOL 3.0; Mac_PowerPC)
America Online 3.0 (Win 95) Mozilla/2.0 (compatible; AOL-IWENG 3.0; Win16)
[FMP-ClientType]
Client Typeu
Replacement
Client Type
HB[FMP-ClientType] is replaced with the current browser client type.
[FMP-ClientUserName]J
Client User Name
What it does
[FMP-ClientUserName] is replaced with the client's user name from HTTP authentication.
Syntax example(s)
Return the client's user name using an HTML file
Your name is: [FMP-ClientUserName]
<!-- After processing it could look like:
Your name is: John
-->
t%[FMP-ClientUserName]
Client User Nameu
Replacement
Client User Name
HV[FMP-ClientUserName] is replaced with the client's user name from HTTP authentication.
[FMP-ContentMimeType]J
Content MIME Type
What it does
[FMP-ContentMIMEType] is replaced with nothing in the HTML and changes the MIME type returned to the browser.
This tag changes the content type line in the HTTP header to the MIME type specified. The default MIME type for format files return by the FileMaker Pro Web Companion is text/html. Consult RFC 2068, Hypertext Transfer Protocol -- HTTP/1.1 for more information about HTTP header lines and MIME type specification. <http://ds.internic.net/rfc/rfc2068.txt>
Syntax
[FMP
-ContentMIMEType: Mime Type ]
Parameter(s)
First parameter: MIME type.
Syntax example(s)
Change the Content MIME type using an HTML file
Some sample [FMP-ContentMIMEType: text/plain] text.
<!-- After processing it could look like:
Some sample text.
-->
[FMP-CurrentAction]J
Current Action
t'[FMP-ContentMimeType]
Content MIME Typeu
Replacement
Content Mime Type
Hm[FMP-ContentMIMEType] is replaced with nothing in the HTML and changes the MIME type returned to the browser.
[FMP-CurrentAction]J
Current Action
What it does
[FMP-CurrentAction] is replaced with the name of the current action, such as: find, findall, new, edit, delete, view, or dup.
Syntax
[FMP-CurrentAction: Encoding ]
Parameter(s)
First parameter: Encoding. Use one of the following reserved words:
HTML - (default) Perform HTML encoding
Display - Returns the action in the language specified by the Web Companion Configuration
Syntax example(s)
Return the name of the current action using an HTML file
Last action was: B_[FMP-CurrentAction]
<!-- After processing it could look like:
Last action was: view
-->
t"[FMP-CurrentAction]
Current Actionu
Replacement
Current Action
Ht[FMP-CurrentAction] returns the name of the current action, such as: find, findall, new, edit, delete, view, or dup.
[FMP-Cookie]J
Cookie
What it does
[FMP-Cookie] is replaced with the current value of the specified cookie.
A cookie is saved by the browser; therefore, your user's browser must support this feature. Older browsers may not support this feature.
Syntax
[FMP-Cookie: CookieName , Encoding ]
Parameter(s)
First parameter: Name of the cookie to return.
Second parameter (optional): Encoding. Use one of the following reserved words:
Raw - (default) Don't perform any encoding
URL - Perform URL encoding
Syntax example(s)
Return the value of the current cookie using an HTML file
[FMP-If: CurrentCookie:ColorChoice .neq. ""]
Thanks for coming back! The latest products in [FMP-Cookie: ColorChoice]
are listed below.
[/FMP-If]
<!-- After processing it could look like:
Thanks for coming back! The latest products in green
are listed below.
-->
See also
[FMP-SetCookie]
[FMP-Cookie]
Cookieu
URL - Perform URL Encoding
Replacement
Current Cookie
HO[FMP-CurrentCookie] is replaced with the current value of the specified cookie.
[FMP-CurrentDate]J
Current Date
What it does
[FMP-CurrentDate] is replaced with the current date.
Syntax
[FMP-CurrentDate: Format ]
Parameter(s)
First parameter (optional): Format. Use one of the following reserved words:
Short - (default) returns the current date in the OS's definition of a short date (e.g. 3/3/98).
Abbrev - returns the current date in the OS's definition of an abbreviated date (e.g. Tue, Mar 3, 1998).
Long - returns the current date in the OS's definition of a long date (e.g. Tuesday, MarB
ch 3, 1998).
Syntax example(s)
Returns the current date using an HTML file
Current date is: [FMP-CurrentDate]
<!-- After processing it could look like:
Current date is: 3/3/98
-->
[FMP-CurrentDate]
Current Dateu
Replacement
Current Date
H4[FMP-CurrentDate] is replaced with the current date.
[FMP-CurrentDay]J
Current Day
What it does
[FMP-CurrentDay] is replaced with the name of the current day of the week.
Syntax
[FMP-CurrentDay: Format ]
Parameter(s)
First parameter (optional): Format. Use one of the following reserved words:
Short - (default) returns the current day name in the OS's definition of a short day name (e.g. MON).
Long - returns the current day name in the OS's definition of a long day name (e.g. Monday).
Syntax example(s)
Returns the current day using an HTML file
Current day iBgs: [FMP-CurrentDay: Long]
<!-- After processing it could look like:
Current day is: Monday
-->
[FMP-CurrentDay]
Current Dayu
Replacement
Current Day
HJ[FMP-CurrentDay] is replaced with the name of the current day of the week.
[FMP-CurrentError]J
Current Error
What it does
[FMP-CurrentError] is replaced with the FileMaker Pro error number from the current action. For information on possible result numbers, search FileMaker's onscreen Help for status functions and then find "Status(CurrentError) function".
Syntax example(s)
Return the current error number using an HTML file
The last operation failed with error number [FMP-CurrentError].
<!-- After processing it could look like:
The last operation failed with error number 500.
-->
t [FMP-CurrentError]
Current Erroru
Replacement
Current Error
[FMP-CurrentError] is replaced with the FileMaker error number from the current action. See FileMaker error code numbers for possible results.
[FMP-CurrentFind]J
Current Find
What it does
Repeats the HTML between [FMP-CurrentFind] and [/FMP-CurrentFind] for each find criteria that was part of the request that created this page.
Syntax example(s)
Return information about the current find using an HTML file
Repeats the HTML between [FMP-CurrentFind] and [/FMP-CurrentFind] for each find criteria that was part of the request that created this page.
[FMP-CurrentFoundCount]J
Current Found Count
LWhat it does
[FMP-CurrentFoundCount] is replaced with the total number of records in the current found set.
Syntax example(s)
Returns the total number of records in the found set using an HTML file
Record(s) in found set: [FMP-CurrentFoundCount]
<!-- After processing it could look like:
Record(s) in found set: 12
-->
t+[FMP-CurrentFoundCount]
Current Found Countu
Replacement
Current Found Count
H^[FMP-CurrentFoundCount] is replaced with the total number of records in the current found set.
[FMP-CurrentLOP]J
Current Logical Operator
JWhat it does
[FMP-CurrentLOP] is replaced with the logical operator used for the current search.
Syntax example(s)
Returns the current logical operator using an HTML file
You just did an "[FMP-CurrentLOP]" style search.
<!-- After processing it could look like:
You just did an "or" style search.
-->
See also
-LOP
t)[FMP-CurrentLOP]
Current Logical Operatoru
Replacement
Current Logical Operator
HS[FMP-CurrentLOP] is replaced with the logical operator used for the current search.
[FMP-CurrentRecID]J
Current Record ID
What it does
[FMP-CurrentRecID] is replaced with the record key
a number representing the current record.
If [FMP-CurrentRecID] is placed between the [FMP-Record] and [/FMP-Record] tags, [FMP-CurrentRecID] is replaced with the record key of each record in the sequence.
[FMP-CurrentRecordCount] is replaced with the total number of records in the database.
Syntax example(s)
Returns the total number of records in the database using an HTML file
Total number of records in the database is: [FMP-CurrentRecordCount]
<!-- After processing it could look like:
Total number of records in the database is: 1123
-->
tabase is: 1123
-->
3.<br>
-->
See also
-RecID, [FMP-LinkRecID]
t-[FMP-CurrentRecordCount]
Current Record Countu
Replacement
Current Record Count
HV[FMP-CurrentRecordCount] is replaced with the total number of records in the database.
[FMP-CurrentRecordNumber]J
Current Record Number
@What it does
[FMP-CurrentRecordNumber] is replaced with the record's position in the current found set.
Syntax example(s)
Returns the current record number using an HTML file
Current record in found set: [FMP-CurrentRecordNumber]
<!-- After processing it could look like:
Current record in found set: 3
-->
t/[FMP-CurrentRecordNumber]
Current Record Numberu
Replacement
Current Record Number
HZ[FMP-CurrentRecordNumber] is replaced with the record's position in the current found set.
[FMP-CurrentSkip]J
Current Skip Setting
~What it does
[FMP-CurrentSkip] is replaced with the number of records skipped from the beginning of the found set. This is useful as a value to pass to the -Skip tag.
Syntax example(s)
Returns current record with -Skip instead of -RecID using a link
[FMP-CurrentSkip] is the number of records skipped from the beginning of the found set. This is useful as a value to pass to the -Skip tag.
t$[FMP-CurrentSort]
Current Sort Orderu
Replacement (looping)
Current Sort
Repeats the HTML between [FMP-CurrentSort] and [/FMP-CurrentSort] for each sort argument that was part of the request that created this page.
[FMP-CurrentTime]J
Current Time
What it does
[FMP-CurrentTime] is replaced with the current time.
Syntax
[FMP-CurrentTime: Format ]
Parameter(s)
First parameter (optional): Format. Use one of the following reserved words:
Short - (default) returns the current time in the OS's definition of a short time (e.g. 10:12 AM).
Long - returns the current time in the OS's definition of a long time (e.g. 10:12:32 AM).
Syntax example(s)
Returns the current time using an HTML file
Current time is: [FMP-CurrentTime: shoBTrt]
<!-- After processing it could look like:
Current time is: 10:12 AM
-->
[FMP-CurrentTime]
Current Timeu
Replacement
Current Time
H4[FMP-CurrentTime] is replaced with the current time.
[FMP-CurrentToken]J
Current Token
What it does
[FMP-CurrentToken] is replaced with the value of -Token variable tag used to create the current page.
Syntax
[FMP-CurrentToken: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Returns the current token using an HTML file
Your last reply was [FMP-CurrentToken: HTML].
<!-- After processing
it could look like:
Your last reply was sell.
-->
See also
-Token
Revert Record
[FMP-Field]
Fieldu
Replacement
Field
HA[FMP-Field] is replaced with the contents of the specified field.
ied by the -Lay tag that was part of the request that created this page must contain the fields to be displayed. Related fields cannot be used if the -Lay tag was not specified.
Syntax
[FMP-Field: Field name , Encoding ]
Parameter(s)
First parameter: The name of the field
Second parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encodingd name , Encoding ]
Parameter(s)
First parameter: The name of the field
Second parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
2Dvsyntax:
[FMP-If: CurrentToken:5.eq.{CurrentToken:6}]
<B>Token 5 equals token 6.</B>
[/FMP-If]
See also
-Token
tag would then have an optional
specifier that would look like CurrentToken:3 if you want to compare the contents of token
three to something else.
Example format file snippet:
<!-- Pass the value of token three onto the next request -->
<INPUT
TYPE="HIDDEN" NAME ="-Token.3" VALUE ="[FMP-CurrentToken: 3]">
Tokens can be used on the right side of an FMP-If using the intratag replacement syntax:
[FMP-If: Curren
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Break - Perform HTML encoding and replace soft returns with <br>
Syntax example(s)
Create an editable area for field data using an HTML file
First Name: <input type="text" name="First Name" value="[FMP-Field: First Name, Raw]">
Return field data using an HTML file
First Name: [FMP-Field: First Name]
<!-- After processing it could look like:
First Name: John
-->
[FMP-FindFieldItem]J
Find Field Item
What it does
[FMP-FindFieldItem] is replaced with the field name that was part of the find request that created this page.
[FMP-FindFieldItem] must be placed between the [FMP-CurrentFind] and [/FMP-CurrentFind] tags.
Syntax
[FMP-FindFieldItem: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Hc[FMP-FindValueItem] is replaced with the value that was part of the request that created this page.
[FMP-Header]J
Header
What it does
The HTTP header of the page sent to the browser is replaced with the text between the [FMP-Header] and [/FMP-Header] tags. None of the text between the tags will appear in the HTML portion of the page.
The [FMP-Header] tag must be placed before the [FMP-ContentMimeType] and [FMP-SetCookie] tags in order for them to function properly. The [FMP-Header] tag will replace the current header entirely. Since these tags modify the header, their position is important.
One exampl
[FMP-Header]
Headeru
Replacement
Header
HzThe HTTP header of the page sent to the browser is replaced with the text between the [FMP-Header] and [/FMP-Header] tags.
[FMP-If]J
What it does
Along with the [FM-Else] and [/FMP-If] tags, the [FMP-If] tag controls what HTML is shown by the browser. The [FMP-Else] tag is optional.
Syntax
[FMP-If: LeftSide Operator RightSide ]
...HTML if condition is true...
[FMP-Else]
...HTML if condition is false...
[/FMP-If]
Parameter(s)
First parameter: The left side of the operator. Can be one of the following reserved words:
Boolean comparisons
CanDelete - Do password privileges allow for deleting records?
me="doe", position="Software Engineer", -find] [FMP-Field: first name] [FMP-Field: last name] [/FMP-InlineAction]
<!-- Send a mail message if a cookie was never set -->
e of the use of a header would be to redirect a browser to a different HTTP server instead of displaying the formatted page. Consult RFC 2068, Hypertext Transfer Protocol -- HTTP/1.1 for more information about HTTP headers.
Syntax example(s)
Direct the user's browser to the FileMaker home page after processing the request
[FMP-Header]
HTTP/1.0 302 Moved Temporary
Location: http://www.FileMaker.com
[/FMP-Header]
Other tags that are required
[/FMP-Header]
nEdit - Do password privileges allow for editing records?
CanNew - Do password privileges allow creation of new records?
IsSorted - Is the database currently sorted?
Numeric comparisons
CurrentError - Returns the current error number. See FileMaker Pro error code numbers, in the develop guide section of this database, for possible values
CurrentFoundCount - Returns how many records are in the found set
CurrentMax - Returns the current -Max value, which describes how many reco
rds should be shown
CurrentRecordCount - Returns how many records are in the database
CurrentRecordNumber - Returns the current record number
CurrentSkip - Returns how many records were skipped to the beginning of the range
RangeEnd - Returns the record number of the last record in the range
RangeSize - Returns the number of records that were actually shown in the range
RangeStart - Returns the record number of the first record in the range
Text comparisons
ClientPasswor
[FMP-If]
field
Replacement
Along with the [FM-Else] and [/FMP-If] tags, the [FMP-If] tag controls what HTML is shown by the browser. The [FMP-Else] tag is optional.
[FMP-Image]J
Image
What it does
[FMP-Image] is replaced with an image URL pointing to the picture in the specified field.
Usually used inside the HTML image (<img>) tag or anchor (<a>) tag as the URL to the picture.
Syntax
[FMP-Image: Field name ]
Parameter(s)
First parameter: The name of a container field
Syntax example(s)
Display a picture using an HTML file
<img src="[FMP-Image: pictures]">
Link to a picture using an HTML file
<a href="[FMP-Image: pictures]">View the image!</a>
See alsB
-Img
le(s)
Display a picture using an HTML file
<img src="[FMP-Image: pictures]">
Link to a picture using an HTML file
<a href="[FMP-Image: pictures]">View the image!</a>
See alsB
-Img
CurrentRecordNumber - Returns the current record number
CurrentSkip - Returns how many records were skipped to the beginning of the range
RangeEnd - Returns the record number of the last record in the range
RangeSize - Returns the number of records that were actually shown in the range
RangeStart - Returns the record number of the first record in the range
Text comparisons
ClientPasswor
nDelete .eq. True]
Show the delete button...
[/FMP-If]
Address example
[FMP-If: ClientAddress .eq. keith.company.com]
Hi, Keith!
[/FMP-If]
Text example
[FMP-If: CurrentAction .eq. Delete]
[include: filename.htm]
[FMP-Else]
[include: anotherFile.htm]
[/FMP-If]
[FMP-If: First Name .eq. field: Nick Name]
How boring, your nick name is the same as your name.
[/FMP-If]
[FMP-If: ClientUserName .neq.]
Everyone who has entered a user name will see thiK
s message.
[/FMP-If]
value list item should be checked
Field: Field Name - Name of a field to compare with
Literal Value - Any literal text that does not contain a ] character (right square bracket)
Date/time comparisons (only with eq, neq, gt, gte, lt, lte)
Literal Value - Proper date, day, or time literal in current OS's format
Address comparisons (only with eq)
List of Literal Value - list of address or IP numbers, with wild cards if wanted, separated by commas
Notes about lite
ral values:
If specifying a literal value, FileMaker Pro treats everything from the end of the operator to the closing right square bracket (minus leading and trailing blanks) as the comparison value.
Don't enclose literal values in quotes. If you include quotes, they're treated as part of the comparison value.
Literal values are not case-sensitive and can include spaces within text or number values.
Syntax example(s)
Boolean example
Decide which HTML to send:
[FMP-If: Ca
ress - Returns the domain address
ClientIP - Returns the IP address
Second parameter: The comparison operator
.eq. - equals
.neq. - not equal to
.gt. - greater than
.gte. - greater than or equal to
.lt. - less then
.lte. - less than or equal to
.cn. - contains
.ncn. - does not contain
Third parameter: The right side of the operator, depends on the comparison type of the left side.
Boolean comparisons (only with .eq. and .neq. operators)
False
True
Nume
ric comparisons (only with eq, neq, gt, gte, lt, lte)
Field: Field Name - Name of a field to compare with, should be a number
Literal Numeric Value - A number
Text comparisons (all operators allowed)
Field: Field Name - Name of a field to compare with
Literal Value - Any literal text that does not contain a ] character (right square bracket)
Value list comparisons (all operators, except for Checked, which can only use eq)
Checked - Used with .eq. to test if the
d - Returns the client's password
ClientType - Returns the type of browser the Web user is using
ClientUsername - Returns the client's user name as typed in by the Web user in the authentication dialog box
CurrentAction - Returns the current action (e.g.: Delete, New)
CurrentCookie: Cookie Name - Returns the value of the named cookie
CurrentDatabase - Returns the current database name
CurrentFormat - Returns the name of the current format file
CurrentLayout - Returns the cur
rent layout name
CurrentToken - Returns the current token value
Text or numeric comparisons depending on field type
Field: Field Name - Name of a field to compare with
Value list comparisons
ValueListItem - Returns the current value list item
Date/time comparisons
CurrentDate - Returns the current date in short format
CurrentDay - Returns the current day name in short format
CurrentTime - Returns the current time in short format
Address comparisons
ClientAdd
[FMP-Image]
Imageu
Replacement
Image
HY[FMP-Image] is replaced with an image URL pointing to the picture in the specified field.
[FMP-Include]J
Include
|What it does
[FMP-Include] is replaced with the contents of another file, usually an HTML format file.
Syntax
[FMP-Include: Filename ]
Parameter(s)
First parameter: Name of the file to include.
Syntax example(s)
Include a file using an HTML file
[FMP-If: CurrentError .eq. 509]
[FMP-Include: requirefield.htm]
[FMP-Else]
[FMP-Include: othererror.htm]
[/FMP-If]
[FMP-Include]
Includeu
Replacement
Include
HY[FMP-Include] is replaced with the contents of another file, usually an HTML format file.
[FMP-LinkFirst]J
Link First
What it does
The HTML between [FMP-LinkFirst] and [/FMP-LinkFirst] is replaced with a link to the first range of records based on the -Max value used to create the current page.
The link that is generated includes all the search and sort criteria that was used to generate the page this tag was on. The text between the two tags is not displayed if the first record is being displayed.
Syntax example(s)
Display first set of records using an HTML file
[FMP-LinkFirst]First set of recordsBV.[/FMP-LinkFirst]
HlThe HTML between [FMP-LinkFirst] and [/FMP-LinkFirst] is replaced with a link to the first range of records.
[FMP-LinkLast]J Link Last
What it does
The HTML between [FMP-LinkLast] and [/FMP-LinkLast] is replaced with a link to the last range of records based on the -Max value used to create the current page.
The link that is generated includes all the search and sort criteria that was used to generate the page this tag was on. The text between the two tags is not displayed if the last record is being displayed.
Syntax example(s)
Display the last set of records using an HTML file
[FMP-LinkLast]Last set of records.BU[/FMP-LinkLast]
HiThe HTML between [FMP-LinkLast] and [/FMP-LinkLast] is replaced with a link to the last range of records.
[FMP-LinkNext]J Link Next
What it does
The HTML between [FMP-LinkNext] and [/FMP-LinkNext] is replaced with a link to the next range of records based on the -Max and -Skip values used to create the current page.
The link that is generated includes all the search and sort criteria that was used to generate the page this tag was on. The text between the two tags is not displayed if the last record in the found set is being displayed.
Syntax example(s)
Display the next set of records using an HTML file
[FMP-LiBunkNext]Next set of records[/FMP-LinkNext]
HkThe HTML between [FMP-LinkNext] and [/FMP-LinkNext] is replaced with a link to the next range of records.
[FMP-LinkPrevious]J
Link Previous
What it does
The HTML between [FMP-LinkPrevious] and [/FMP-LinkPrevious] is replaced with a link to the previous range records based on the -Max and -Skip value used to create the current page.
The link that is generated includes all the search and sort criteria that was used to generate the page this tag was on. The text between the two tags is not displayed if the first record in a found set is being displayed.
Syntax example(s)
Display the previous set of records using an HTML fileB
[FMP-LinkPrevious]Previous set of records[/FMP-LinkPrevious]
HJ[FMP-LinkRecID] is replaced with a URL to a specific record in a database.
[FMP-Option]J
Option
What it does
[FMP-Option] is replaced with all the values in the value list of the field in that layout.
Syntax
[FMP-Option: Field Name , List=Value List Name ]
Parameter(s)
First parameter: Name of a field that the value list is associated with.
Second parameter (optional): Name of a value list to use, the default is to use the value list associated with the field on the specified layout.
Syntax example(s)
Display a pop-up menu with value list using an HTML file
<select name=
|"Groups">
[FMP-option: Groups, list=GroupList]
</select>
<!-- After processing, the HTML sent to the browser could look like:
<select name="Groups">
<option> Production
<option selected> Sales
<option> Support
</select>
-->
Other tags that are required
-Lay (required if you haven't specified a list), <select>, </select>
See also
[FMP-ValueList]
[FMP-Option]
Optionu
Replacement
Option
H[[FMP-Option] is replaced with all the values in the value list of the field in that layout.
[FMP-Portal]J
Portal
What it does
Repeats the HTML between [FMP-Portal] and [/FMP-Portal] for each record in a specified portal.
The layout specified by the -Lay tag that was part of the request that created this page must contain fields specified by the relationship in this tag. This tag cannot be used if the -Lay tag was not specified.
Syntax
[FMP-Portal: Relationship name ]
Parameter(s)
First parameter: Name of the relationship to repeat over.
H^Repeats the HTML between [FMP-Portal] and [/FMP-Portal] for each record in a specified portal.
[FMP-RangeEnd]J Range End
What it does
[FMP-RangeEnd] is replaced with the record number of the last record being displayed.
Syntax example(s)
Display the record number of the last record in the range using an HTML file
Records [FMP-RangeStart] through [FMP-RangeEnd] of [FMP-CurrentFoundCount]
<!-- After processing it could look like:
Records 6 through 10 of 34
-->
See also
[FMP-RangeStart]
[FMP-RangeEnd]
Range Endu
Replacement
F Range End
HAo[FMP-RangeEnd] is the replaced with the record number of the last record being displayed (i.e. 11 through 20)
[FMP-RangeSize]J
Range Size
What it does
[FMP-RangeSize] is replaced with the number of records actually displayed on this page.
Usually this is equal to [FMP-CurrentMax] except in the case when you are at the end of the record list and -Max records are not available.
Syntax example(s)
Display the current number of records being viewed using an HTML file
You are viewing [FMP-RangeSize] records.
<!-- After processing it could look like:
You are viewing 8 records.
-->
See also
-Max
[FMP-RangeSize]
Range Sizeu
Replacement
Range Size
HW[FMP-RangeSize] is replaced with the number of records actually displayed on this page.
[FMP-RangeStart]J
Range Start
What it does
[FMP-RangeStart] is replaced with the record number of the first record being displayed.
Syntax example(s)
Display the record number of the first record being displayed using an HTML file
Records [FMP-RangeStart] through [FMP-RangeEnd] of [FMP-CurrentFoundCount]
<!-- After processing it could look like:
Records 6 through 10 of 34
-->
See also
[FMP-RangeEnd]
[FMP-RangeStart]
Range Startu
Replacement
Range Start
Record Ranges
HAn[FMP-RangeStart] is replaced with the record number of the first record being displayed.
(i.e. 11 through 20)
[FMP-Record]J
Record
What it does
Repeats the HTML between [FMP-Record] and [/FMP-Record] for every record up to -Max, starting after skipping -Skip records.
Syntax example(s)
Display several records using an HTML file
[FMP-Record]
[FMP-Field: Country] - [FMP-Field: Capital]<br>
[/FMP-Record]
<!-- After processing it could look like:
Great Britain - London
France - Paris
USA - Washington D.C.
-->
Other tags that are required
[/FMP-Record]
See also
-Max, -Skip
[FMP-Record]
Recordu
Replacement (looping)
Record
H{Repeats the HTML between [FMP-Record] and [/FMP-Record] for every record up to -Max, starting after skipping -Skip records.
[FMP-Repeating]J Repeating
What it does
Repeats the HTML between [FMP-Repeating] and [/FMP-Repeating] for all the repetitions of the specified field. The tag [FMP-RepeatingItem] is replaced with the contents of a specific repetition.
Repeating fields within portals are not supported. The number of repetitions displayed in a repeating field is controlled by the layout specified in the -Lay tag.
Repeats the HTML between [FMP-Repeating] and [/FMP-Repeating] for all the repetitions of the specified field. The tag [FMP-RepeatingItem] is replaced with the contents of a specific repetition.
[FMP-RepeatingItem]J
Repeating Item
What it does
[FMP-RepeatingItem] is replaced with the contents of the next repetition.
Syntax
[FMP-RepeatingItem: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Break - Perform HTML encoding and replace soft returns with <br>
HI[FMP-RepeatingItem] is replaced with the contents of the next repetition.
[FMP-SetCookie]J
Set Cookie
What it does
The [FMP-SetCookie] tag is replaced with nothing in the HTML and is used to store a variable in the user's browser. It is used to store information that will be needed in future visits.
A cookie is saved by the browser. Therefore your user's browser must support this feature, and the user must have the feature enabled.
Consult the Preliminary Specification for Persistent Client State HTTP Cookies from Netscape for more information about Cookies. <http:/search.netscape.co
[FMP-SetCookie]
Set Cookieu
Replacement
Set Cookie
The [FMP-SetCookie] tag is replaced with nothing in the HTML and is used to store a variable in the user's browser. It is used to store information that will be needed between visits.
nName ]
Parameter(s)
First parameter: The name and value for the cookie
CookieName - The name of the cookie. Must be fewer than 1024 characters. Can either be the contents of a field specified by "field: fieldname" or a text constan
CookieValue - The data value of the cookie. Must be fewer than 1024 characters. Can either be the contents of field specified by "field: fieldname" , the reserved word CurrentRecID, or a text constant.
Other parameters (optional): These may appear in any order.
Expires - The number of minutes in the future that the cookie will expire. If not set, the cookie will expire at the end of the user's session. A value of 0 or a negative number may be used to have cookies expire immedia
al machine so that the next time you visit our site
within the next month we will display the latest products that come in the
color green.
-->
See also
[FMP-Cookie]
ately.
Path - Sets the path attribute for the cookie. 'Pathname' must be fewer than 256 characters. If not specified, the path defaults to the path to FileMaker Pro.
Domain - Sets the domain attribute for the cookie. 'Domain' must be fewer than 256 characters. If not set, the domain defaults to the domain of the server.
The total number of characters between the opening and closing square brackets of the [FMP-SetCookie] tag must be less than 2048.
Syntax example(s)
Set a cookie
using an HTML file
You have selected your favorite color to be [FMP-Field: ColorChoice]. A "cookie"
has been set on your local machine so that the next time you visit our site
within the next month we will display the latest products that come in the
You have selected your favorite color to be green. A "cookie"
has been set on your loc
[FMP-SortFieldItem]J
Sort Field Item
What it does
[FMP-SortFieldItem] is replaced with the field name that was part of the request that created this page.
[FMP-SortFieldItem] should be placed inside the [FMP-CurrentSort] and [/FMP-CurrentSort] tags.
Syntax
[FMP-SortFieldItem: Encoding ]
Parameter(s)
First parameter: Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Return information about the-SortFieldItem: Encoding ]
Parameter(s)
First parameter: Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Return information about the
m/newsref/std/cookie_spec.html>. You may also check the Cookies and Privacy FAQ from netscape at <http:/search.netscape.com/assist/security/faqs/cookies.html>
First parameter: The name and value for the cookie
CookieName - The name of the cookie. Must be fewer than 1024 characters. Can either be the contents of a field specified by "field: fieldname" or a text consta
CookieValue - The data value of the cookie. Must be fewer than 1024 characters. Can either be the contents of field specified by "field: fieldname" , the reserved word CurrentRecID, or a text constant.
Other parameters (optional): These may appear in any order.
Expires - The number of minutes in the future that the cookie will expire. If not set, the cookie will expire at the end of the user's session. A value of 0 or a negative number may be used to have cookies expire immedi
<!-- After processing, the HTML sent to the browser could look like:
<input type="radio" name="Groups"
value="Production">Production
<input type="radio" name="Groups"
value="Sales" checked>Sales
<input type="radio" name="Groups"
value="Support">Support
-->
Other tags that are required
[FMP-ValueList], [/FMP-ValueList]
See also
[FMP-ValueListItem], [FMP-Option]
t)[FMP-ValueListChecked]
Value List Checkedu
Replacement
Value List Checked
[FMP-ValueListChecked] is replaced with the word "checked" for every value list item that has been selected in the specified field.
[FMP-ValueListItem]J
Value List Item
What it does
[FMP-ValueListItem] is replaced with the next element of a value list.
[FMP-ValueListItem] must be placed between the [FMP-ValueList] and [/FMP-ValueList] tags.
Syntax
[FMP-ValueListItem: Checked, Encoding ]
Parameter(s)
First parameter (optional): Checked. Use one of the following reserved words:
Checked - Replace with the value list item if it is selected in the database. Replace with nothing if the value list item is not selected in the database.
Always - (defau
fmp-repeatingitem@
lt) Always replace with the value list item.
Second parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Display value list as radio buttons using an HTML file
Field - The name of the field that you want the data to go into.
Data - The information that should be placed into the field.
Checked (o
Data - The information that should be placed into the field.
Selected (optional) - Specifies that the scrolling list item is selected. If the word "selected" is not present, the scrolling list item is not selected.
Visible Value - The value that the user sees in the browser.
An HTML input type. Used by a browser to create a button that will be used to perform an action. FileMaker Pro Action tags can be used with a submit button.
TextJ
What it does
An HTML input type. Used by a browser to display a single line of text.
This is not a FileMaker Pro tag, This is standard HTML.
Do not include calculation or summary field types on add or update format files as data can't be entered into these field types.
Syntax
<input type="text" name="Field" value="Data">
Field - The name of the field that you want the data to go into.
Data - The information that should be placed into the field.
Syntax example(s)
Display a te
Text Field
HHAn HTML input type. Used by a browser to display a single line of text.
TextAreaJ Text Area
What it does
An HTML input type. Used by a browser to display multiple lines of text.
This is not a FileMaker Pro tag, This is standard HTML.
Do not include calculation or summary field types in an add or update format files as data can't be entered into these field types.
Syntax
<textarea name="Field" rows=Rows cols=Columns > Data </textarea>
Field - The name of the field that you want the data to go into.
Rows - Number of rows of text to display.
Columns - Number of charact
t Text
Textu
ers to display per row.
Data - The information that should be placed into the field.
Specifies the FileMaker script that should be performed before the finding and sorting of records (if any) during processing of the action.
-Script.PreSortJ
Perform Script Before SortL
<none>
What it does
Specifies the FileMaker Pro script that should be performed after the finding and before the sorting of records (if any) during processing of the action.
[FMP-CurrentFormat] is replaced with the name of the current format file being processed.
Syntax
[FMP-CurrentFormat: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Returns the name of the current format file, using an HTML file
This page was formatted with file: [FMP-CurrentFormat].
<!-Bs- After processing it could look like:
This page was formatted with file: Detail.htm.
-->
See also
-Format
at file, using an HTML file
This page was formatted with file: [FMP-CurrentFormat].
<!-Bs- After processing it could look like:
This page was formatted with file: Detail.htm.
-->
See also
-Format
t&[FMP-CurrentDatabase]
Current Databasev
Replacement
Current Database
HP[FMP-CurrentDatabase] is replaced with the name of the database being processed.
t'[FMP-CurrentFormat]
Current Format Filev
Replacement
Current Format
HY[FMP-CurrentFormat] is replaced with the name of the current format file being processed.
[FMP-CurrentLayout]J
Current Layout
What it does
[FMP-CurrentLayout] is replaced with the name of the layout being used to process this page.
Syntax
[FMP-CurrentLayout: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Returns the name of the current layout, using an HTML file
This page was formatted using the layout: [FMP-CurrentLayout].
<!-- After processing it could look like:
This page was formatted using the layout: Detail Layout.
-->
See also
-Lay
t"[FMP-CurrentLayout]
Current Layoutv
Replacement
Current Layout
H\[FMP-CurrentLayout] is replaced with the name of the layout being used to process this page.
[FMP-CurrentMax]J
Current Max
What it does
[FMP-CurrentMax] is replaced with the maximum number of records that was specified to be displayed on this page. It is the value of the -Max variable that was passed in.
Syntax example(s)
Returns the current -Max value, using an HTML file
Click the button at the bottom of the page
to see the next [FMP-CurrentMax] records.
<!-- After processing it could look like:
Click the button at the bottom of the page
to see the next 10 records.
-->
See also
-Max
[FMP-CurrentMax]
Current Maxv
Replacement
Current Max
Hg[FMP-CurrentMax] returns the maximum number of records that was specified to be displayed on this page.
[FMP-FieldName]J
Field Name
What it does
[FMP-FieldName] is replaced with the name of the current field when this tag is between the [FMP-LayoutFields] and [/FMP-LayoutFields] tags.
Syntax
[FMP-FieldName: Encoding ]
Parameter(s)
First parameter (optional): Encoding. Use one of the following reserved words:
Raw - Don't perform any encoding
URL - Perform URL encoding
HTML - (default) Perform HTML encoding
Syntax example(s)
Create a pop-up menu with all the fields on a layout, using an HTML file
<select
name="-SortField">
<option value="">-None- [FMP-LayoutFields]
<option>[FMP-FieldName: Raw] [/FMP-LayoutFields]
</select>
<!-- After processing, the HTML sent to the browser could look like:
<select name="-SortField">
<option value="">-None-
<option>First Name
<option>Last Name
<option>Employee Number
</select>
-->
Other tags that are required
[FMP-LayoutFields], [/FMP-LayoutFields]
[FMP-FieldName]
Field Namev
Replacement
Field Name
[FMP-FieldName] is replaced with the name of the next field when this tag is between the [FMP-LayoutFields] and [/FMP-LayoutFields] tags.
[FMP-LayoutFields]J
Layout Fields
What it does
Repeats the HTML between [FMP-LayoutFields] and [/FMP-LayoutFields] for all the fields on the layout specified by the -Lay tag that was part of the request that created this page.
Syntax example(s)
Create a pop-up menu with all the fields on a layout, using an HTML file
<select name="-SortField">
<option value="">-None- [FMP-LayoutFields]
<option>[FMP-FieldName: Raw] [/FMP-LayoutFields]
</select>
<!-- After processing, the HTML sent to the browser could look lB
<select name="-SortField">
<option value="">-None-
<option>First Name
<option>Last Name
<option>Employee Number
</select>
-->
Other tags that are required
[/FMP-LayoutFields]
See also
-Lay, [FMP-FieldName]
t [FMP-LayoutFields]
Layout Fieldsv
Replacement (looping)
Layout Fields
Repeats the HTML between [FMP-LayoutFields] and [/FMP-LayoutFields] for all the fields on the layout specified by the -Lay tag.
[FMP-Link]
section of the url
l - omit layout section of the url
s - omit sort criteria section of the url
f - omit find criteria section of the url
m - omit max section of the url
k - omit skip section of the url
t - omit token section of the url
a - omit action section of the url
Syntax example(s)
Change to a page using all the same criteria except for the format file, using a link
[FMP-Link] is replaced with a URL that points to the page it is on. The parameters can be used to remove portions of the URL it generates.
The link that is generated includes all the find and sort criteria that was used to generate the page this tag is on. This tag is a shortcut to the following series of CDML tags:
Closes a database on the FileMaker host machine from a remote browser.
The -DBOpen and -DBClose actions tags would only use the -db variable tag for the name of the database and the partial path before FMPro? in the URL to determine on which database to apply the action. The database administrator will have to have remote administration privileges and the database to be closed must be in the Web folder. A format file is required to be specified in the URL in order for -DBO
pen to be processed.
For security reasons, it is important to use the Remote Administration Requires Password option, otherwise users can close your database without an Administrator password.
Specify Host...:FileMaker host name is limited to 32
Unknown
0an unexpected TCP/IP error (
AppleTalk is not enabled ( TCP/IP couldn't be initialized (:the manually set TCP/IP address is configured improperly (Jthe TCP/IP address is already in use or an address could not be obtained (
; This file is created and used by FileMaker Pro for TCP/IP access.
; It should contain one IP address or host name per line.
; Lines starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
changeC
change
content
using
changed
changes
character~
charactercodes
characters~
check
checkbox
checkboxes
checked
checking
chris
citizen
click
client
contacts&-format
contain~
containerG
containingG
contains~
content
contentsC
continue
control~
convertedG
copied
correctG
countryC
createB
createsH
criteriaD
current
currenterror}
currenttoken
custom
dataI
databaseA
mailfrom
mailsub
mailhost
mailformat
action
Help IDB
DescriptionB
HeaderB
Dev Guide Sub TopicB
H1 CalcB
K = "Yes"
"" )
H2 CalcB
"" )
Current TopicB
SA Bar StateB
Menu StateB
Button1B
S = "All"
Button2B
S = "Variable"
Variable
Button3B
S = "Action"
Action
Button4B
S = "Replacement"
Replacement
Button5B
S = "HTML"
12/10/2001
getting
started
custom
publishingA
guest
plug-inF
publishingA
reference
startedA
using
using
withA
t [FMP-CurrentToken]
Current Tokenu
Replacement
Current Token
He[FMP-CurrentToken] is replaced with the value of -Token variable tag used to create the current page.
[FMP-Field]J
Field
What it does
[FMP-Field] is replaced with the contents of the specified field.
The layout specified by the -Lay tag that was part of the request that created this page must contain the fields to be displayed. Related fields cannot be used if the -Lay tag was not specified.
Syntax
[FMP-Field: Field name , Encoding ]
Parameter(s)
First parameter: The name of the field
Second parameter (optional): Encoding. Use one of the following reserved words:
<INPUT TYPE="SUBMIT" NAME="-Edit" VALUE="Edit This Record">
</FORM>
See also
-ModID
t*[FMP-CurrnetModID]
Current Modification IDv
Replacement
[FMP-CurrentPortalRowNumber]J
Current Portal Number
{ieldItem]
[FMP-SortOrderItem]
[FMP-ValueList]
[FMP-ValueListChecked]
[FMP-ValueListItem]
[FMP-ValueNameItem]
[FMP-ValueNames]
-Format
-MailBCC
-MailCC
-MailFormat
-MailFrom
-MailHost
-MailSub
-MailTo
Pop up Menu
Radio Buttons
-RecID
-Script
-Script.PreFind
-Script.PreSort
Scrolling List
-Skip
-SortField
-SortOrder
Submit
Text Area
-Token
-View
-DBClose
Database Closev
Action
-ErrNum
Error Numberv
Variable
of error numbers or an individual error number that triggers the use of the format page specified in the -Error tag. Multiple -ErrNum tag may be used to specify discontinuous ranges. If no -ErrNum exists, then the current behavior is used. Any error not listed in -ErrNum tags will be handled by the default pages inside the Web Companion. Errors related to finding and processing an -Error format page will always be handle with the default pages.
alue is
Path and name to the format file to use to display the error message.
-ErrNum which takes either a range of error numbers or an individual error number that trigger the use of the format page specified in the -Error tag. Multiple -ErrNum tag may b
URL - Perform URL encoding
HTM
no number paramet
er then token
zero would be returned. CurrentToken constant for the FMP-If tag would then have an optional
specifier that would look like CurrentToken:3 if you want to compare the contents of token
three to something else.
Example format file snippet:
<!-- Pass the value of token three onto the next request -->
<INPUT TYPE="HIDDEN" NAME ="-Token.3" VALUE ="[FMP-CurrentToken: 3]">
Tokens can be used on the right side of an FMP-If using the intratag replacement syntax:
[FMP-If: Curren
Start up Script
Main Menu
Developer's Guide
Developer's Guide Detail
CDML Tag Index
Find all Tags
Find a Tag...
Cancel Find
Continue Find
Find Action Tags
Find Variable Tags
Find Replacement Tags
Find HTML Tags
Find - Using CDML Tool
Descriptions
# List View
' CDML Tool
Help...
Credits...
Go to Description Layout
Go Next Record
Go Previous Record
etail
CDML Tag Index
Find all Tags
Find a Tag...
Cancel Find
Continue Find
Find Action Tags
Find Variable Tags
Find Replacement Tags
Find HTML Tags
Find - Using CDML Tool
Descriptions
# List View
' CDML Tool
Help...
Credits...
Go to Description Layout
Go Next Record
Go Previous Record
[FMP-IncludeField]J
Include Field
2ed with the specified data if the conditions of the [FMP-If] statement are not met.
Syntax example(s)
Generate a greeting unique to the locale of the user
-ErrNum takes either a range of error numbers or an individual error number that triggers the use of the format page specified in the -Error tag. Multiple -ErrNum tag may be used to specify discontinuous ranges. If no -ErrNum exists, then the current behavior is used. Any error not listed in -ErrNum tags will be handled by the default pages inside the Web Companion. Errors related to finding and processing an -Error format page will always be handle with the default pages.
e of the format page specified in the -Error tag. Multiple -ErrNum tag may be use
What it does
Used to detect record modification collisions in -Edit requests. If the ID does not match, error code 306 (Record modification ID does not match) is returned.
Value is
An email address.
Syntax example(s)
Make sure when updating the country, no one else changed it
<INPUT TYPE="SUBMIT" NAME="-Edit" VALUE="Edit This Record">
</FORM>
Other tags that are required
-Edit, [FMP-CurrentRecordID]
See also
-[FMP-CurrentRecordID]
entRecordID]
order
order
subject
submit
address
token
value
value
checked
value
value
value
names
What it does
[FMP-InlineAction] allows the processing of multiple CDML requests during the processing of a single format file. The [FMP-InlineAction] tag takes as its parameters the URL-like format of the name value pairs for a CDML request. All further processing of the format file then continues as if the inline request started the processing.
When the [/FMP-InlineAction] is processed the request that was in effect previously is restored. Any -Format tags are ignored in the re
quest. [FMP-CurrentError] contains the error result number of the last [FMP-InlineAction]. Any FMP-ContentMIMEType or FMP-Header tags inside any [FMP-InlineAction] tags are processed as if they were not inside any [FMP-InlineAction] tags.
Syntax
[FMP-InlineAction: Intratags ]
Parameter(s)
First parameter: Intratags{intratag parameter}
Syntax example(s)
<!-- List the employees named Doe in the current database -->
[FMP-InlineAction: -db={CurrentDatabase}, -lay={CurrentLayout}, last na
recordA
record
recordsE
repeat
repeating
repeating
reset
response}
script|
scrolling
scrolling
cookie
setting
records
field
field
order
order
start
subject
subject
submit
address
token
value
value
10&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
order
password
perform|
perform
script|
perform
script
before
perform
script
before
pop-up
pop-up
portal
previous
radio
radio
buttons
range
range
range
range
start
field
order
start
subject
subject
address
token
value
viewI
formI
0a&-find
1&-findD
1&-skip
10&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
current
action
current
database
current
current
current
error
current
current
format
current
found
count
current
layout
current
logical
operator
current
current
modification
current
portal
number
current
record
count
current
record
current
record
number
current
repeat
number
current
setting
current
order
current
current
token
databaseJ
database
close
database
nameJ
database
nameJ
names
recordH
number
operator
option
previous
recordA
record
recordsE
response}
script|
setting
records
field
order
subject
subject
address
token
value
viewI
formI
0a&-find
1&-findD
1&-skip
10&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
imageG
include
include
field
inline
inline
action
layout
layout
fields
layout
first
previous
record
logical
logical
operator
records
modification
modification
0a&-find
1&-findD
1&-skip
10&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
error}
error
format
field
error
number
error
response}
field~
field
name~
fields
findD
recordsE
recordF
field
operator
recordD
value
first
formI
format
format
field
format
field
format
format
found
header
&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
deleteA
delete
recordA
displayG
display
imageG
duplicateB
duplicate
recordB
editC
recordC
email
findD
recordsE
recordF
recordD
formI
format
format
imageG
layout
layout
logical
logical
operator
nameJ
recordH
operator
perform|
perform
script|
recordA
recordsE
response}
script|
viewI
formI
0a&-find
1&-findD
1&-skip
10&-find
10&-findallE
10&-max
10&-skip
10:12
10:12:32
11&picturesG
13&countryC
14&-error
15&-token
17.17.17.17
199.199.9.9
2&fname
date/time
fmp-repeating
aol-iweng
appear
appears
applies
apply
arbitrary
bob&-find
bobbie
boolean
-DBCloseJ
Database Close
2der. A format file is required to be specified in the URL in order for -DBOpen to be processed.
UE is blank, which will display as an entry "field" in the Web browser. These three text areas correspond with the field names in the FileMaker Pro database Guest Book.fp5. The First Name, Last Name, and Email Addre
doesA
whatever
when~
where
whichA
win16
win95
windows
withA
specifiesJ
specifies
email
address
person
sending
specifies
email
address
person
message
specifies
field
sorting
specifies
format
generate
successful
specifies
subject
email
specify}
specifying
spheres
square
standard
standarderror
start~
started
starting
state
statement
states
status
store
storedG
string
style
subject
subject
submitA
supported
syntax
html&-max
html&-op
html&-sortfield
html&-token
http-authenticated
http/1.0
http/1.1
hypertext
hyphen~
iceland
ignored~
imageG
imagesG
immediately
fmp-currenttoken
fmp-else
fmp-elseif
fmp-fieldG
fmp-field
country
fmp-field
capital
fmp-fieldname
fmp-fieldname
encoding
fmp-fieldname
replaced
current
field
fmp-findfielditem
fmp-findfieldnameite
fmp-findfieldvalueit
fmp-findopitem
fmp-findopitem
replaced
search
operator
fmp-findvalueitem
fmp-header
fmp-if}
fmp-imageG
fmp-include
fmp-includefield
fmp-inlineaction
fmp-inlinerequest
fmp-layoutfields
fmp-link
fmp-linkfirst
fmp-linklast
fmp-linknext
fmp-linkprevious
action
fmpro
method
current
order
current
order
currentaction
currentcookie
currentdatabase
currentdate
currentday
currenterror}
currentformat
currentfoundcount
currentlayout
currently
currentmax
currentmodid
currentrecid
currentrecordcount
currentrecordnumber
currentskip
currenttime
currenttoken
custom
dataI
databaseA
date/time
fmp-repeating
mailfrom
mailsub
mailhost
mailformat
action
request@
requirefield@
rslt@
sample@
also@
session@
spec@
specification@
specified@
specifies@
submits@
syntax@
syntax
example
than@
between
fmp-linkfirst
fmp-linkfirst
replaced@
thru@
useful@
value
value
versions@
does@
within@
application@
file@
about
companion
plug-in@
getting
started
custom
publishing@
requestD
requests
requireI
requiredA
response}
result
resultsA
retrieveG
retrieved
returnF
return
information
about
current
using
return
information
about
current
using
returnedD
returnsG
right
rightside
filemakerG
filemaker's
filename
filesI
findD
findallE
findanyF
finding|
findsE
firstD
first
parameter
first
parameter
repeating
field
firstname
nothing
fmp-contentmimetype
fmp-cookie
fmp-currentaction
fmp-currentdate
fmp-currentdate
format
fmp-currentdate
replaced
current
fmp-currentday
typeA
typed
types
uk&-lop
uniqueG
united
update
updatesC
updating
upload~
uploaded~
url-like
usuallyG
valid
valueA
lists
literal
local
locale
location
logical
london
machine
machineone
macintosh
mailbcc
mailcc
mailcc
mailbcc
mailformat
mailfrom
mailhost
mailsub
mailto
mainly
manner~
march
match
maximum
value
valuelistitem
values
variable~
sample
saved
script|
script&-findall|
scrolling
searchD
second
secret
secret&-dbopen
section
security
sizeC
skipD
skipped
slightly
snippet
someD
sample
fmp-contentmimetype
text/plain
sample
something
sortfield
sorting|
sortorder
sorts
specific~
specification
2147483647
3/3/98
4&-deleteA
4&-find
43200
5&-findall
500-509&-edit
6&-dupB
accept
access
accessing
actionA
consider
considered
constant
constants
consult
contact
contacts
contacts&-format
contain~
containerG
containingG
contains~
content
contentsC
continue
continues
control~
controlled
count
countryC
createB
created
createsH
creation
criteriaD
cubes
curdb
current
fmp-currenterror}
fmp-currentfind
fmp-currentformat
fmp-currentfoundcoun
fmp-currentlayout
fmp-currentlop
fmp-currentmax
fmp-currentmodid
fmp-currentportalrow
fmp-currentrecidA
fmp-currentrecordcou
fmp-currentrecordid
fmp-currentrecordnum
fmp-currentrepeatnum
fmp-currentskip
fmp-currentsort
fmp-currenttime
fmp-currenttime
format
fmp-currenttime
replaced
current
follow
following
follows
formA
action
fmpro
method
[FMP-CurrentModID]J
Current Modification ID
What it does
The -ModID tag is an optional tag that can be used with a -Edit action request. The value would be the modification id that has to match the record before the -Edit action can complete successfully and a new error code (306) would be returned if the mod ids did not match. If there is no -Mod tag then the -Edit action would work as it currently does. In addition CurrentRecID and CurrentModID would be added as constants to the FMP-If tag as numeric types.
HeAn HTML input type used to reset all other HTML input types on the page back to their default values.
-DBOpenJ
Database Open
What it does
Opens a database on the FileMaker host machine from a remote browser.
The -DBOpen and -DBClose actions tags only uses the -db variable tag for the name of the database and the partial path before FMPro? in the URL to determine on which database to apply the action. The opening action has the additional parameter -password specifying what password to open the db with. The database administrator must have remote administration privileges . The database must be in the Web fol
result number of the last [FMP-InlineAction]. Any FMP-ContentMIMEType or FMP-Header tags inside any [FMP-InlineAction] tags are processed as if they were not inside any [FMP-InlineAction] tags.
Syntax
[FMP-InlineAction: Intratags ]
Parameter(s)
First parameter: Intratags{intratag parameter}
Syntax example(s)
<!-- List the employees named Doe in the current database -->
[FMP-InlineAction: -db={CurrentDatabase}, -lay={CurrentLayout}, last name="do
What it does
Specifies a field from which a format file can be used for the body of the email message instead of a file in the Web folder.
The format file can contain CDML replacement tags.
Hm[FMP-ContentMIMEType] is replaced with nothing in the HTML and changes the MIME type returned to the browser.
" name="Country" value="F1">France
<input type="checkbox" name="Country" value="G7
t$-MailBCC
Blind Carbon Copy for Emailu
DevGuide
Variable
HMSpecifies the email address of the person that should be blind carbon copied.
Using the CDML Tool
The CDML Tool interacts between open FileMaker Pro databases and HTML editing applications to help you construct format files quickly and reduce syntax errors.
You can start a new format file by:
using one of the format file templates in the CDML Tool
copying CDML tags from the CDML Tool to existing HTML pages
modifying one of the format files in the Web folder
Follow these general steps to use the CDML Tool:
1. Open and share your FileMaker Pro database using Web Companion shari
HTML. The CDML Reference database focuses primarily on CDML syntax. For information on HTML tags, refer to an HTML reference book.
E*Getting started with Custom Web PublishingG
-DupJ
Duplicate Record
What it does
Duplicates the record specified by -RecID.
The -RecID tag indicates which record should be duplicated. To duplicate a record, the Web user must have Create permission for the database.
Syntax example(s)
Duplicate a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=6&-Dup">Duplicate record with ID 6</a>
Duplicate a record using a form action
<form action="FMPro" method="post">
<input type="hidden" name="-DB" value="name.fp5">
<input type=
name="-DB" value="name.fp5">
<input type=
text/html
text/plain
textarea
t$[FMP-CurrentRecID]
Current Record IDu
Replacement
Current Record ID
H_[FMP-CurrentRecId] is replaced with the record key
a hex value representing the current record.
3.<br>
-->
See also
-RecID, [FMP-LinkRecID]
items generated using the dynamic or static approach. In this example, the value list items will be generated using the static method, since the value list items aren't likely to
lusively, you can disable Instant Web Publishing.
To disable Instant Web Publishing:
1. Choose Preferences from the Edit menu, and then choose Web Companion.
If you don't see the Web Companion menu choice, the Web Companion plug-in is either not enabled or not installed correctly.
2. In the Web Companion View Setup dialog box, click Configure.
3. In the Web Companion Configuration dialog box, deselect Enable Instant Web Publishing.
4. Click OK.
eb servers,
E+Considerations before publishing a databaseG
-ScriptJ
Perform ScriptL
<none>
ers. Don't put sensitive documents inside the Web folder.
If anyone opening a FileMaker file has Export Records privileges (even as a guest to a FileMaker file), they can th
versions
viewI
format
using
linkI
viewed
viewing
visible
visit
visits
wanted
washington
This guide explains how to work with the CDML tags, which allow you to specify how your FileMaker Pro 5 data is published on the Web.
In addition to providing general information on custom database publishing, this guide explains how to construct format files (HTML pages that contain CDML tags). Format files determine how Web users interact with your FileMaker Pro 5 database.
This guide also explains how to use the CDML Tool, along with the CDML templates and an HTML editing applicatioWeb users interact with your FileMaker Pro 5 database.
This guide also explains how to use the CDML Tool, along with the CDML templates and an HTML editing applicatio
About the Web Companion plug-inG
-FindAnyJ
Find Any Record
What it does
Performs a find for a single random record. A format file is used to display the record found.
A Web user must have Browse permission in order to execute this action.
Syntax example(s)
Find any one record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&-FindAny">Return any record in the database</a>
r Pro Web Companion performs the duties of both the Web server and the CGI application.
Note Third-party CGI applications that have been compatible with FileMaker Pro 3.0/4.x should continue to work with FileMaker Pro Unlimited, which is availble seperately.
About the Web Companion plug-inG
-NewJ
New Record
What it does
Creates a new record and populates that record with the contents of any field name/value pairs.
A Web user must have Create permission in order to execute this action.
The -RecID tag indicates which record should be deleted. In order to delete a record, the Web user must have Delete permission for the database.
Syntax example(s)
Delete a record using a link
<a href="FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=4&-Delete">Delete record with ID 4</a>
Delete a record using a form action
<form action="FMPro" method="post">
<input type="hidden" name="-DB" value="name.fp5">
<input type="hidden"
P-CurrnetModID]
*[FMP-CurrnetModID]
Current Modification ID
rtal Number
input
mailcc
value
company
input
mailfrom
value
chris
company
input
mailsub
value
subject
input
mailto
value
keith
company
inside
instead
internet
internic
into~
intratag
intratags
invoiceid
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
gettingA
getting
started
custom
publishingA
guest
plug-inF
publishingA
reference
startedA
using
using
withA
checkbox
dbclose
dbopen
delete
errnum
error
errorfmtfield
field~
field
name~
findall
findany
fmp-clientaddress
fmp-clientip
fmp-clientpassword
fmp-clienttype
fmp-clientusername
fmp-contentmimetype
fmp-cookie
fmp-currentaction
fmp-currentdatabase
fmp-currentdate
fmp-currentday
fmp-currenterror
fmp-currentfind
fmp-currentformat
fmp-currentfoundcoun
fmp-currentlayout
fmp-currentlop
fmp-currentmax
fmp-currentmodid
fmp-currentportalrow
action
fmpro
method
cdmlB
cdmltagname1
choice|
choices
chooseD
choosingJ
clarisC
click|
clicksG
clipboard
coded
coding}
collectsH
comingH
commentsE
commonH
commonly
communicatingG
companionC
compatibleH
complete
completed
complex
complexityJ
compriseJ
computerD
conditional
configurationD
configure|
connectedD
connectionC
considerJ
considerationsJ
consistsC
constant}
constructB
containB
containing|
containsD
contentJ
contentsG
continueH
copying
copying
existing
pages
corporate
correctly|
corresponds
could
email
address
input
browser
create
button
input
browser
display
checkbox
anchor
another
anotherfile
iweng
appear
appears
applies
apply
arbitrary
methodA
microsoft
minus
minutes
modid
modification
modify
monday
month
moved
mozilla/2.0
mozilla/3.0
mozilla/3.01
multiple~
mustA
nameA
numbers
formatA
formatfile
formatsG
formatted
foundD
fp3&-recid
fp5&-errorfmtfield
fp5&-fmtfield
fp5&-formatA
fp5&-lay
formE
formatB
format
files
pages
contain
typically
format
files
contain
formatfilename&-anac
formats
formattingH
foundH
frames
frequently}
fromE
functionality
functionsG
gatewayH
header
helpB
helpfulE
here'sD
here's
overview
steps
required
publish
hidden
homeC
hostingD
however}
htmlB
input
html-formattedG
httpG
hundredsJ
hyperlink|
hypertextG
identifiedG
identifies
imageD
importantJ
ascend
ascending
associated
assumed
attempt}
attribute
australiaH
australia&-newH
authentication
available
based
beforeG
beginning
begins
behavior
beingG
below
better
between
blanks
blind
machineD
mailing
makeD
makesB
making
mechanismG
menu|
mightJ
mindJ
minimumD
modelE
modifyJ
moreD
mostE
moveC
moviesJ
much}
mustC
nameD
names}
natureJ
navigateJ
needC
needed}
needs}
next|
noteB
notifiedH
notifies
number
onscreenB
openD
openingJ
option}
optionalD
orderH
ordersJ
otherB
otherwiseB
overallJ
overviewD
pageC
pagesB
paperJ
passH
passesH
passwordsJ
pathD
performD
performance}
performsH
placingD
planningJ
platform-independentG
plug-inD
pop-up}
preferencesD
preventJ
primarilyB
privilegesJ
createB
created
createsE
customizeC
dataB
databaseB
databasename&-format}
databasesC
deciding}
default|
deletedJ
deleting
deliversG
demonstrateE
demonstratesE
department}
dependJ
depending}
depends
deselect|
designedE
designingC
details}
determineB
determines
developer'sB
diagramJ
diagrammingJ
dialogD
disableD
display}
displayed|
displaying
displaysG
distributingJ
documentC
documentsJ
don'tJ
dutiesH
dynamic}
dynamically}
eachJ
easilyC
easyJ
edit|
editingB
eitherH
elements
employeeE
employees}
enableC
enabledD
enablesE
enabling|
engineering}
evaluatesH
evenJ
eventsH
every}
exampleE
examples}
letsC
levelJ
pages
default
guest
solution
likely}
limited
lines
linkD
linkedJ
linksJ
listJ
listedJ
lists
located}
locatesG
locationG
locatorG
logical
longer
looping
lower
includeE
includedH
includesG
including
incorporates}
increase
increases
indexB
indicates
indicating
industry
informationB
informationB
informationB
installed|
instantB
instructions
interactB
interactionH
interactivity
interactsH
interfaceC
internetC
interpretsG
intoC
intranetC
ipaddress/fmpro}
ipaddress/formatfile}
isn't
it'sJ
itemsE
keepJ
layoutJ
layout-specific
layoutsJ
addressC
advantage}
after}
after
determine
database
activity
alerts
allowB
allowsC
alongB
already
alsoB
amountJ
ampersand
animated
anyoneJ
appear
appearanceC
appearingJ
appears
appleH
applets
applicable
applicationB
applicationsG
approach}
appropriate
areas
aren't}
arrow
assigned
assistE
assistantC
attribute
existingD
explainsB
explore
exploring|
exportJ
extended
factor}
factorsJ
fairly
familiarityB
features
fieldJ
fieldsJ
fileB
filemakerB
filemaker
functions
server
communicating
filename|
filesB
filled
filled-out
first}
flowchartJ
fmp-field
fmp-valuelist}
fmp-valuelistitem}
fmpro
focusesB
folderD
folders
follow
follow
these
general
steps
follow
these
increase
performance
followed
followingD
thanG
thanks
thatA
typeA
uk&-lop
uniqueG
united
updatesC
upload~
uploaded~
usa&-editC
usa&-maxD
usedD
userA
usesJ
usingA
usuallyG
valueA
value
variable~
viewI
format
using
linkI
jpegG
keith
keyword
kingdom
known
label
language
latest
layout
leading
leftside
lengthy
letters
limitD
manyJ
marketing}
mechanismG
menu|
messages
method
mightJ
mindJ
minimal
minimumD
modelE
modified
modifyJ
modifying
modifying
format
files
folder
monitors
moreD
mostE
moveC
moved
moviesJ
much}
mustC
nameD
name2
names}
natureJ
navigateJ
necessary
needC
needed}
needs}
next|
non-ascii
one-line
one-lined
onscreenB
openD
opened
openingJ
perform|
performanceD
performed|
performsF
period~
creatingB
critical
crossB
current
cursor
customB
customizeC
dataB
deciding}
default|
deletedJ
deleting
deliversG
demonstrateE
demonstratesE
department}
dependJ
depending}
depends
deselect|
designedE
designingC
details}
determineB
determines
developer'sB
diagramJ
diagrammingJ
dialogD
directly
disableD
display}
displayed|
displaying
displaysG
distributingJ
documentC
documentsJ
don'tJ
dutiesH
dynamic}
dynamically}
eachJ
easilyC
easyJ
edit|
editingB
eitherH
element
elements
employeeE
employees}
enableC
enabledD
enablesE
enabling|
engineering}
evaluatesH
evenJ
eventsH
every}
exampleE
automated
automatically}
availableJ
availbleH
backG
background
basicB
becauseJ
beenH
beforeH
being}
below
best}
better}
betweenG
blank
bookB
bothH
bottom
breaking
broadcastingJ
browseE
browserG
browsersG
browsing
build
built-inJ
button
buttons
can't
cannot
captures
capturing
cartE
cases}
catalogE
category
cd-rom
examples}
exclusively|
executing
databaseB
databasename&-format}
databasesC
deciding}
decimal
default|
define
delete
deletedJ
deletes
deleting
deliversG
demonstrateE
demonstratesE
department}
dependJ
depending}
depends
description
deselect|
design
designates
designedE
designer
designingC
detail
determining
developer'sB
diagramJ
diagrammingJ
dialogD
directly
disableD
display}
displayed|
displaying
displaysG
distributingJ
documentC
documentsJ
doesn't
don'tJ
dutiesH
dynamic}
dynamically}
eachJ
easilyC
easyJ
edit|
specifiedA
specifierG
person
sending
specifies
email
address
person
message
specifies
field
sorting
specifies
format
generate
successful
specifies
subject
email
specify}
specifying
start~
states
status
storedG
string
style
subject
subject
submitA
submitsD
subset
success}
successful
support
syntaxA
generalB
generated|
generates
gettingB
giveD
graphic
graphics
guestE
guideB
handle
handlesH
handling
hard}
haveC
header
helpB
helpfulE
here'sD
here's
overview
steps
required
publish
hidden
higher
homeD
hostingD
however}
htmlB
input
imageD
images
importantJ
editingB
edits
eitherH
element
elements
email
employeeE
employees}
empty
enableC
enabledD
enablesE
enabling|
encode
encoded
encoding
engineering}
enter
entered
entity
entry
error
errors
evaluate
evaluatesH
evenJ
every}
exact
examines
exampleE
input
insertJ
inserted
inserting
inserts
insideJ
install
installedE
instantB
instead
instructions
interactB
interacting
interactionH
interactivity
interactsH
interfaceC
internetC
interpretsG
intoC
intranetC
ipaddress/fmpro}
ipaddress/formatfile}
ipaddress/path/fmpro
ipnumorname/path/fmp
isn't
issues
it'sJ
itemsE
keepJ
label
layoutJ
layout-specific
layoutsJ
layoutsJ
webserver
welcome
whatA
words
would
yourD
noteB
these
instructions
build
format
started
notifiedH
notifies
number
objects
occur
offer
one-line
one-lined
onscreenB
openD
opened
openingJ
operate
operator
operators
option}
optionalD
optional
elements
graphics
animated
changeD
changingC
chapterB
character
characters
checkbox
choice|
choices
chooseD
choosingJ
clear
click|
clicksG
clipboard
close
coded
coding}
collectsH
comingH
commentsE
commonH
commonly
communicatingG
companionC
company
compatibleH
complete
completed
complex
complexityJ
compriseJ
computerD
conditional
configurationD
configure|
configuring
connectedD
connectionC
considerJ
considerationsJ
considered
consistsC
constant}
constructB
inueH
copying
copying
existing
pages
corporate
correctly|
corresponds
could
contact
containB
container
containing|
containsD
contentJ
contentsG
continueH
control
controls
converting
copying
copying
existing
pages
corporate
correctly|
correspond
corresponding
corresponds
could
html-formattedG
html/web
httpG
hundredsJ
hyperlink|
hypertextG
identifiedG
identifies
imageD
images
importantJ
addition
enabling
companion
plug-in
applica|
addition
format
files
contain
general
publishing
database
includesH
inappropriate
doesA
domain
domainname
don't
duplicateB
duplicate
record
using
linkB
duplicatedB
duplicatesB
duplicates
record
specified
recidB
during|
editC
editable
editedC
editing
either~
element
email
enabled
enclose
encoding
fp5&-recidG
fp5&keyG
france
france
paris
fromG
front
function
functions
further
future
generateG
generated
generates
germany
given
going
great
great
britain
london
greater
green
greeting
grouplist
groups
guide
handle
handled
hasseen
details}
determineB
determines
determining
developerE
developer'sB
diagramJ
diagrammingJ
dialogD
direct
directly
directoryE
disableD
display}
displayed|
displaying
displaysG
distributingJ
documentC
documentsJ
doesn't
don'tJ
dpi's
dutiesH
dynamic}
dynamically}
eachJ
easilyC
easyJ
edit|
edited
anotherH
anyoneJ
appear
appearanceC
appearingJ
appears
applets
applicable
applicationB
applicationsG
approach}
appropriate
areas
aren't}
arrow
ascii
assigned
assistE
attribute
attributes
auto-enters
de to access the HTML tags.
4. Delete any text, including HTML tags, that the application may have automatically inserted.
The template files already contain the necessary standard HTML tags.
5. From the Web folder, open the Guest Book.fp5 database.
6. From the Web Tools folder, open the CDML Tool database.
7. In the Templates tab of the CDML Tool, choose Guest Book.fp5 from the Database list.
All open FileMaker Pro 5 database names appear in the Database list.
8. Choose the Form
View layout.
All layouts in the selected database appear in the Layouts list.
Note The layout choice determines which fields FileMaker Pro can access. Including the Layout name increases performance because it reduces the number of fields that FileMaker Pro needs to evaluate. However, all the fields that are added to the format file must be on the specified layout. If no Layout CDML tag has been specified, FileMaker Pro designates Layout 0 as a special virtual layout, which contain
2. From the Web Tools folder, open the CDML Tool.
3. Choose the database and layout names in the Templates tab.
By specifying a database and layout name, you customize the CDML syntax in the template text and some CDML tags.
4. Open an HTML editing application.
Since you
ll be working with two applications simultaneously, it
s best to position the CDML Tool window next to the HTML page that you
ll be creating.
5. In the CDML Tool, copy a template from the Format File (Action)
list in the Templates tab.
6. Paste the template text into a blank HTML editing document.
7. From the Tags tab of the CDML Tool, copy and paste additional CDML tags into the appropriate location in the format file.
Create one format file to handle each database interaction.
For step-by-step instructions, see the next two sections: "Using the CDML templates" and "Adding CDML tags to format files."
Important considerations when using the CDML Tool:
FileMaker Pro 5 files cannot be op
in the Guest Book.fp5 database, but cannot add, search, edit, or delete records. For an example of a more complex Web site, explore the Shopping_cart and Employee_database format files. All the solution files in the Web folder can be viewed in any text or HTML editing application.
E%Exploring the Guest Book format filesG
-MailSubJ
Subject for MailL
<none>
whether you want to have the value list items generated using the dynamic or static approach. In this example, the value list items will be generated using the static method, since the value list items aren't likely to
(.txt)